Friday, March 9, 2012

How to return a result from a procedure?

I created a procedure to select data. It works fine on SQLPlus. but I can't get any result from front-end which implemented in Coldfusion.
Does any one have an idea how to return a set values from a procedure?
Your reply is appreciate.You can do something like this...

CREATE OR REPLACE PROCEDURE ProcA
(a_dMonth IN DATE,
a_nStatus OUT NUMBER
)
AS

Now call the procedure in a sql script...

declare
nStatus Number :=0;
e_exception EXCEPTION;
begin
ProcA(to_date(&&1,'yyyymmdd',nStatus);
if nStatus > 0 then
dbms_output.put_line('yr message '||nStatus);
raise e_exception;
end if;
EXCEPTION
when e_exception then
null;
end;
/|||Thanks, I got it.

No comments:

Post a Comment