Rather than building a select statement in application code then
sending it to the database for execution, I'd like to send some
parameter values into a stored procedure and then let it conditionally
build the select statement for me, execute it, and then return the
results to the application. I've gotten to the point where I can send
in parameters and my select statement is built, but how do I go about
executing my select statement string from within the stored
procedure? How do I send back the results? Is this possible if I
don't know what columns will be included in the results until the
parameters are sent in (e.g. true/false parameters such as
IncludeColumnA, IncludeColumnB, etc)?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
