I'd like to create a procedure/function which would allow me to pass
an entire SQL query as parameter.
For test purposes, I succeeded in making a procedure that gets the
name of a table and, by concatenating this variable with 2 strings
looking like 'select field1, field2 from ' and ' where ...'. But my aim is to
pass a completeselect statement, from the 'select' till the final 'order
by...', as a parameter.
The problem is: is this possible ? How to declare the necessary variables,
how to arrange it so that ANY query could be completely handled by this
procedure ??? Did anybody already write such PL/SQL code, using the
'dbms_sql' package and its pre-defined procedures and functions ?
Any help would be greatly appreciated !! Could you send your responses
to sebastien.rigaud_at_dg12.cec.be ?
Thanks a lot in advance !
regards,
Received on Sat Dec 07 1996 - 00:00:00 CET