Re: Mapping View Columns to Procedure/Function Parameters
Date: Sun, 10 Apr 2016 23:57:14 -0400
Message-ID: <570B209A.80004_at_gmail.com>
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-lReceived on Mon Apr 11 2016 - 05:57:14 CEST