这个没有错误: --------------------------------- DECLARE TYPE Number_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; Tblnumber Number_Array; Csrwk NUMBER; Nret NUMBER; Vsql VARCHAR2(1024) := 'select 1 from dual'; BEGIN Csrwk := Dbms_Sql.Open_Cursor; Dbms_Sql.Parse(Csrwk, Vsql, Dbms_Sql.Native); Dbms_Sql.Define_Column(Csrwk, 1, Nret, 12); Nret := Dbms_Sql.EXECUTE(Csrwk); Dbms_Sql.Close_Cursor(Csrwk);END;
我按你说的更了,还是一样啊
---------------------------------
DECLARE
TYPE Number_Array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
Tblnumber Number_Array;
Csrwk NUMBER;
Nret NUMBER;
Vsql VARCHAR2(1024) := 'select 1 from dual';
BEGIN
Csrwk := Dbms_Sql.Open_Cursor;
Dbms_Sql.Parse(Csrwk, Vsql, Dbms_Sql.Native);
Dbms_Sql.Define_Column(Csrwk, 1, Nret, 12); Nret := Dbms_Sql.EXECUTE(Csrwk);
Dbms_Sql.Close_Cursor(Csrwk);END;