Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level V

Run Stored procedure in SQL with JSL

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.

 

 
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
pmroz
Super User

Re: Run Stored procedure in SQL with JSL

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

1 REPLY 1
Highlighted
pmroz
Super User

Re: Run Stored procedure in SQL with JSL

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

Article Labels