DSXchange

Hi,

I need to call a oracle function through datastage. Function doesn't have any arguments.What it does is it returns a return code with 1 or 0.

select function_name() from dual.

This is working fine with PL/SQL developer client. I have used the same statement in user defined SQL and defined a column as Return Code in Oracle Enterprise stage/DRS stage .But its throwing below error message

main_program: aptoci.C:446 failed. Message: ORA-00911: invalid character.

I even tried using STP stage but no luck.

Could you please share you ideas on this.

Thanks in Advance.

Hi,
What is the datatype of the return port you are using?

You can user user-defined sql -
select function_name as retval from dual

This will also work

Regards
Sreeni