Stored Procedure return value

[Former Member]

Good Afternoon

Experts:

I have code that passes parameters to a Stored Procedure. Now I want to be able to return a value back from the Stored Procedure.

How can I achieve this in my calling code to the S/P?

Thanks,

Ed

[former_member201110 · Accepted solution]

Hi Ed,

I don't know of a way to use a return parameter from within the SAPBobsCom recordset object (...if someone else knows then I'd be keen to hear). You may have to find a way to return your value in the recordset itself. Alternatively you could use ADO.Net to call your stored procedure but that opens a whole load more issues to do with the DB connection.

Incidentally, SAP addon certification forbids the use of your own stored procedures within the SBO databases. To stick within certification rules you'd need to have your procs in a separate database and pass the actual DB as a parameter.

Kind Regards,

Owen

[Former Member]

Hi,

I do not think it Return Parameters can be done with SBO DI API.

But you can use temporary table in Stored Procedure. Use that table store return value. As a last statement you 'select * from' query for temporary result table. This output will be accessible using recordset.

HTH

B Ravi Shankar