This content has been marked as final. Show 1 reply
The PLSQL forum is where you'd want to post PLSQL questions.
However, if you plan on calling it from a client side app, you'll want to stop right now. TABLE%ROWTYPE is a PLSQL-only type, and cant be passed to/from client side applications, which I presume you want to do since you've also provided .NET code. You probably want to look into using a REF CURSOR instead.
Hope it helps,
SQL> ed Wrote file afiedt.buf 1 create or replace function getcurs (stmt in varchar2, tbl in varchar2) return sys_refcursor as 2 retcur sys_refcursor; 3 begin 4 open retcur for stmt||' ' ||tbl; 5 return retcur; 6* end; SQL> / Function created. SQL> var abc refcursor; SQL> exec :abc := getcurs ('select sysdate from ','dual'); PL/SQL procedure successfully completed. SQL> print abc SYSDATE --------- 29-OCT-10 SQL>