cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMPĀ® Marketplace
Choose Language Hide Translation Bar
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
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

2 REPLIES 2
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;" );
mende001
Level I

Re: Run Stored procedure in SQL with JSL

How do you use this function for a SQL Server?