oracle8.0.5是不是不支持动态游标?9i才支持?
以下动态游标在oracle9.2上可以通过,但是在oracle8.0.5上通不过
请教一下,oracle8.0.5是不是不支持动态游标?
CREATE OR REPLACE PROCEDURE mydyn_cursor
(
DEPT_CODE IN VARCHAR
)
IS
sql_select1 VARCHAR2(2000);
type cursor_dyn is REF CURSOR;
GET_DETAILS cursor_dyn;
V_DETAILS simple_table%ROWTYPE;
begin
sql_select1 :='select * from simple_table';
open GET_DETAILS for sql_select1;
loop
FETCH GET_DETAILS into V_DETAILS;
EXIT WHEN GET_DETAILS%NOTFOUND;
dbms_output.put_line(V_DETAILS.f1);
end loop;
close GET_DETAILS;
END mydyn_cursor;