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