Question

我试图执行一种程序,恢复<代码>sys_refcursor,我想使用指挥手段获得治疗,但在我执行诉讼时,我有错误。是否可能? 如下:

create or replace
procedure sp_proc(
  p_vl_skip in number,
  p_vl_take in number,
  tblresult out sys_refcursor)
as
  v_first_row number;
  v_last_row number;
begin
  select p_vl_skip into v_first_row from dual;
  select p_vl_skip + p_vl_take into v_last_row from dual;

  open tblresult for
  with tbl_relacao_rejeicoes as (
    select vl_value1, vl_value2, row_number() over (order by vl_value1 desc) vl_reg
    from tb_table
    order by vl_value1 desc)
  select *
  from tbl_relacao_rejeicoes
  where vl_reg between v_first_row and v_last_row
  order by cd_motivo_rejeicao vl_value1;
end;
/

它汇编了没有任何标识的目录,但在我执行时,我发现:

OracleException: ORA-06550: line 1, column 7:
PLS-00201: identifier  TBL_RELACAO_REJEICOES  must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Answer 1

阁下的第二项命令是:

cd_motivo_rejeicao vl_ Value1;

无效。 “cd_motivo_rejeicao”是你选择的一个栏目吗? 如果是的话,则将 com与vl_ Value1混为一谈。否则,它就会消失。我也不清楚,为什么你根据《选举法》第1条——它没有达到目的? 不管怎么说,我通过确定第二项命令,获得了你的程序。因此,你可以在 cur子内使用该条款。

友情链接