Run Stored procedure in SQL with JSL

[#1]

Hello,

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?

Thank you.

Tom.

[#2 · Accepted solution]

If you're using Oracle this is how I get PL/SQL procedures to work:

Execute SQL( MyConnection, "begin spMyProcedure; end;" );

[#3]

How do you use this function for a SQL Server?