DSXchange

Posted: **Wed Nov 04, 2009 3:24 am**

Hi

How do i call a oracle function in datastage 8.1 version. I have a mod 11 function in oracle which i need to call in my job. please let me know how i can call a oracle function and with which stage i can call it? Thanks in advance.

Regards,
Pavan

Posted: **Wed Nov 04, 2009 4:05 am**

You can use Oracle Enterprise stage.

Posted: **Wed Nov 04, 2009 4:10 am**

[quote="Sainath.Srinivasan"]You can use Oracle Enterprise stage.[/quote]

Can you please let me know how i can do it using oracle enterprise stage?please give me brief steps to implement the same. Thanks

Posted: **Wed Nov 04, 2009 5:16 am**

select function name(parameter) from dual

Posted: **Wed Nov 04, 2009 7:48 am**

The same way you would in any other tool, you 'select' it as a field in a sql statement.

Posted: **Thu Nov 05, 2009 10:29 am**

You can use ODBC stage as well.

Regards
Sreeni

DSXchange

calling oracle function

calling oracle function