3 Replies Latest reply: Nov 3, 2008 7:50 PM by 502182 RSS

    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.