3 Replies Latest reply on Nov 4, 2008 1:50 AM by 502182

    dynamic plsql within stored procedures?


      I've tried to get an example of dynamic plsql in a stored procedure. Is it possible? Where could I find an example?
      Could I use some how the type pls_integer?

      Otherwise the only way that I can see is :create a temp table, inserting the rows from this dynamic pl into this table and
      return a refcursor from this table.