Skip to Content
avatar image
Former Member

Stored Procedure return value

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 21, 2007 at 03:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded