topic Re: Run Stored procedure in SQL with JSL in Discussions

Run Stored procedure in SQL with JSL

tom_abramov — Fri, 09 Jun 2023 23:35:03 GMT

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.

pmroz — Mon, 17 Aug 2020 17:34:56 GMT

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

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

mende001 — Wed, 31 May 2023 21:51:53 GMT

How do you use this function for a SQL Server?