Good day. I have a pkg.proc_production that returns a sys_refcursor (This is in production).
I have a *NEW* pkg.proc_new. I want to call the production pkg.proc_production to obtain the sys_refcursor; however I want to "filter" out some of the rows which have a specific column value. I want to return the "filtered" sys_refcursor to an ASP.NET page which calls my *NEW* pkg.proc_new. Example: pkg.proc_production returns a sys_refcursor with 100 rows. pkg.proc_new calls pkg.proc_production; obtains sys_refcursor; filters out rows with value "X"; returns sys_refcursor to caller. I am trying to get some "reuse" here. Can someone help me with the proper technique? Best, jb --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
