Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> result cursor using dynamic sql
I need to create a procedure that uses DBMS_SQL to generate a dynamic select cursor. How can I return the results of this select as a cursor parameter in the procedure call?
procedure myproc( p_tabname in varchar2, p_dscr in varchar2,
c_result_cursor in out cursor_types.t_c_clear_insd )
begin
vCursor := dbms_sql.open_cursor;
vTabname := upper( p_tabname );
vStmt := 'select ' || vTabName || '_id from ' || vTabName ||
' where upper( dscr )=upper(''' || p_dscr || ''')';
dbms_output.put_line ( vStmt );
dbms_sql.parse(vCursor, vStmt, dbms_sql.v7);
vDummy := dbms_sql.execute( vCursor );
// What now? How do I get the results of vCursor into c_result_cursor?
Thanks
-- Jim Poe (jpoe_at_fulcrumit.com)Received on Wed Jun 20 2001 - 13:24:30 CDT