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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment