Sorry I don't understand.
How would that help to map query against view, say "SELECT RV FROM DYNSQL
WHERE PROC='XXX' AND PARAM='YYY'" to a PL/SQL function call, "XXX('YYY')"?
On 11 April 2016 at 11:57, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
Well, create a table with procedure names and parameter names and types
for every procedure you need to use like that. That seems to be the most
natural solution to your problem.
On 4/10/2016 10:19 PM, Patrick Jolliffe wrote:
We have an application that can easily query a view, but cannot easily--
call a PL/SQL function or procedure.
I am trying to create a custom view to allow this to happen.
For example if application performs the following query:
SELECT RETURN_VALUE FROM TEST_VIEW WHERE PROCEDURE_NAME = 'XXX' AND
PARAM1='YYY' AND PARAM2='ZZZ';
I want to call the function XXXX with the given parameters, ie XXX('YYY',
'ZZZ') and return the values.
I can do the dynamic SQL portion fairly easily (I think), but I am
struggling to understand how I can map the predicates to input and output
parameters to a procedure or function.
Note if handling return value is tricky, might be able to skip that
portion (ie just call procedure XXX('YYY', 'ZZZ').
Any pointers? Thanks in advance.
--
Mladen Gogala
Oracle Consultant
http://mgogala.freehostia.com
DISCLAIMER: I am solely responsible for any opinion expressed in this email
--
//www.freelists.org/webpage/oracle-l