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.
Oracle Function Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am