April 17, 2007 at 10:08 am
Hi,
I have made a connection to oracle server using "Microsoft ODBC connection for Oracle"
Then I made a "Execute SQl task" which contains statement "EXEC GOIL_Pro" where GOIL_Pro is the sp in oracle which odbc is pointing to.
when i execute the task it faile with error ORA-00900:Invalid Sql statement.
when i write simple select query in place of execute command then it executes successfully.
Can somebody please tell me how to execute an Oracle sp using sql task
April 17, 2007 at 10:23 am
I don't know your environment, but have you tried prepending the schema to the sp name?
April 17, 2007 at 12:36 pm
Tried prepending schema but of no use...any other ideas...
April 17, 2007 at 12:40 pm
If memory serves, the 00900 error returns the string it thinks you want to run. Can you tell us what shows up there?
April 19, 2007 at 8:36 am
No response yet !! any ideas are also welcome.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply