I'm using DTS to copy data from a SQL Server database to an Oracle database. That works fine. I am them attempting to run an Oracle Stored Procedure to update my data. I can execute the stored procedure from SQLPLUS and can call it from a cfm page (CFMX) with no errors.
I execute the sp from DTS, using the execute SQL task with the command execute spName. When I run the DTS package, I always get an "ORA-009000 invalid SQL Statement" error. I've tried setting up the connection in DTS as MS ODBC for Oracle, MS OLE for Oracle and Oracle for OLE, and all result in the same error message. At this point, the sp is just a simple update SQL statement. Anyone have any ideas? I'm lost on this one. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
