Re: Calling/Executing Stored Procedure from Oracle Reports

I know that is the best solution. But how to call the function/procedure which is on the server from the Reports Tool.

In article <8eceb6$652$1_at_nnrp1.deja.com>,   mcpmonkey_at_my-deja.com wrote:
> Hello.
>
> The best way is to write/save the function on the server. Then call
 the
> function from the query.
>
> i.e.
> -- Forgive any typos
> CREATE OR REPLACE
> FUNCTION FOO RETURN NUMBER
>
> BEGIN
>
> RETURN(1);
>
> END FOO;
> /
>
> In the query:
>
> SELECT Field1, Field2, FOO
> FROM TABLE
> WHERE FIELD1 = VALUE;
>
> In article <8ecac7$1au$1_at_nnrp1.deja.com>,
> vramkumar_at_my-deja.com wrote:
> > Can anybody help me executing/calling oracle stored procedure from
> > Oracle Reports. I appreciate your help.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CEST