Re: Calling/Executing Stored Procedure from Oracle Reports

From: <mcpmonkey_at_my-deja.com>
Date: 2000/04/28
Message-ID: <8eceb6$652$1_at_nnrp1.deja.com>#1/1


Hello.

[Quoted] 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:

[Quoted] 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. Received on Fri Apr 28 2000 - 00:00:00 CEST

Original text of this message