Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> result cursor using dynamic sql

result cursor using dynamic sql

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 20 Jun 2001 18:24:30 GMT
Message-ID: <9gqpou$qvl@dispatch.concentric.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US