Jump to content


Ryan

Member Since 07 Jun 2007
Offline Last Active Jul 19 2010 02:01 PM
-----

Topics I've Started

Sql Stored Procedure

18 June 2010 - 08:39 PM

I am trying to call a stored procedure, passing the information it needs then have the stored procedure write to a SQL table. Here is what I am calling

$Q = "Exec SQL_procedure_insert ' " $VAR1 + "','" + $VAR2 + "'"
#RETURN = SYS-SQL($Q)

Then I get the error message "Connection is busy with results for another command" and it does not write to the file.

anyone have any idea why this would happen.

The sql command does work properly if you run it from the SQL management studio.

Ryan