Hi, I am trying to execute a SQL

[rummage]

Hi,

I am trying to execute a SQL Server Stored procedure from WebFocus. The SQL stored procedure inserts a row in one of the tables in the databse. My code is as follows

SQL SQLMSS BEGIN SESSION

EX GOA01_SQL.dbo.spgoa_Insert_DPCIOfInterest
'E0C7EBAA-1236-4AE5-ABD3-01DF39E135A3','81','7','';

SQL SQLMSS END SESSION

There are four parameters to this stored procedure. But after executing the procedure, the insertion of the row did not take place. There is no display of error. But the code has failed. What could be the reason?

Thanks
Thambaiya

 

[FOCMAN]

Test this :

SQL SQLMSS

EX GOA01_SQL.dbo.spgoa_Insert_DPCIOfInterest
'E0C7EBAA-1236-4AE5-ABD3-01DF39E135A3','81','7','';

END

 

[rummage]

Thanks FOCMAN. Now the code work. I rally thank you for all your help.

Thambaiya