Re: Mapping View Columns to Procedure/Function Parameters

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 11 Apr 2016 06:47:21 -0400
Message-ID: <570B80B9.7080305_at_gmail.com>

By creating a table with columns like MY_QUERY, MY_PROC and ARG_ARRAY, the last being a PL/SQL table and then putting in all the possible combinations that you want to use like this. Regards

On 4/11/2016 12:35 AM, Patrick Jolliffe wrote:
> 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
> <mailto: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
>
>
>

-- 
--
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

Received on Mon Apr 11 2016 - 12:47:21 CEST