|
Posted by Volker Hetzer on 11/02/05 20:25
paddy_nyr wrote:
> What is the correct syntax for calling an oracle stored procedure and
> getting a retrun value? I created a simple procedure on my oracle database
> for testing and yes I know I could do this in a function but I have a more
> complex procedure that I have created for the creation of reports. I'm
> trying to use ora_parse and ora_bind without much luck. Any help would be
> much appreaciated.
>
> Thanks
>
> CREATE OR REPLACE PROCEDURE P_PHP_PROC_CALL (
> p_survey_code IN VARCHAR2,
> p_request_id OUT NUMBER
> )
> AS
> BEGIN
>
> IF p_survey_code = 'XYZ' THEN
> p_request_id := 12345;
> END IF;
> END;
> /
If you can rewrite your code as a function you could simply
do a "select P_PHP_PROC_CALL(...) from dual"
Dual is a table available to every user for the specific
purpose of calling functions, that is, if you don't use
the functions in any "real" select with real tables.
The typical example is "select sysdate from dual".
Lots of Greetings!
Volker
Navigation:
[Reply to this message]
|