Re: Mapping View Columns to Procedure/Function Parameters

From: Patrick Jolliffe <jolliffe_at_gmail.com>
Date: Mon, 11 Apr 2016 12:35:17 +0800
Message-ID: <CABx0cSW3+FoE5TjjAwC_OhSy2HQp51GaVTozcpR4BZ=085G_YA_at_mail.gmail.com>

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_at_gmail.com> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 11 2016 - 06:35:17 CEST