Page 1 of 1

Stored procedure stage oracle function

Posted: Tue Oct 28, 2008 4:25 pm
by KPReddy
Hi,
We have a oracle function which returns boolean value, how can i get this value using stored procedure stage. I mean what should be the Parameter name, data type etc in DataStage. Thanks in advance.

Posted: Tue Oct 28, 2008 4:57 pm
by chulett
An Oracle function is used in sql, selected like a column would be. You don't need a stored procedure to make use of it.