I am trying to run a store procedure and get an error "Unknown error".
The command I use is
Execute SQL( MyConnection, "Exec spMyProcedure" );
The procedure doesn't return table, it just updates some table in SQL with data from another server.
While executing the procedure in SQL - no problems.
Any ideas? What is the best way to run stored procedures that are supposed to run several minutes and dont return any table?
Go to Solution
If you're using Oracle this is how I get PL/SQL procedures to work:
Execute SQL( MyConnection, "begin spMyProcedure; end;" );
View solution in original post