Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to store function's result into a variable?

512892Jul 7 2006 — edited Jul 10 2006
I know it is basic stuff, but I am not sure how to handle it.
I have a function A which returns date. The problem I am having is I want to use the output of function A as a input of Function B. for example;

Procedure abc
xx number;
yy number;
res date;

begin
case when xx=1 then function A(xx)
when xx=2 then function A(yy)
end as res,

function B (res);
end procedure;

What is the best way to save the output of one function into a variable and then use it as a input parameter to other function?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2006
Added on Jul 7 2006
14 comments
899 views