Stored procedure stage oracle function

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
KPReddy
Participant
Posts: 28
Joined: Wed Jan 25, 2006 12:41 pm
Location: Philadelphia,PA

Stored procedure stage oracle function

Post 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.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”