|
Posted by paddy_nyr on 11/16/82 11:29
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;
/
Navigation:
[Reply to this message]
|