Oracle Function Error

[jagadam]

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.

[ajay.vaidyanathan]

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

[Sreenivasulu]

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

This will also work

Regards
Sreeni