DTS in sql server 2000
I am trying to execute oracle stored procedure from DTS - ExecuteSQL task
2) exec schema name.procedure name
Getting following error : invalid sql statement.
tried running the same statement in SQL*plus, there the statement execute properly
not sure y execute procedure does not work in ExecuteSQL task for oracle. Need help on urgent basis???