Solved: Run Stored procedure in SQL with JSL

tom_abramov · Jun 9, 2023 4:35 PM

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 · Aug 17, 2020 01:34 PM

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

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

pmroz · Aug 17, 2020 01:34 PM

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

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

mende001 · May 31, 2023 05:51 PM

How do you use this function for a SQL Server?

Run Stored procedure in SQL with JSL