PDA

View Full Version : How pass the return value of a function to the Next step



kuntal_srakar
05-10-2007, 11:56 PM
Hi,

In my transformation, I have a step Execute SQL Script, in that I am
calling a database function. I want to captute the return value of the
function and would like to pass to the next step. How this can be achieved.

/* Function Definition */

Create Or Replace Function Fun(x in Number) return Varchar2 is
l_var varchar2(100);
Begin
selec name
into l_var
from emp
where emp_id =x;
End;

/* Kettle Step */

Select Fun( 5) from Dual;

Regards,
Kuntal