Mark Wong wrote: > I have a moderately simple scenerio where I lose the value of > one of my > output parameters in a stored procedure. There are minor differences > between the following 2 stored procedures that are attached. A 'diff' > displays them plainly enough. I think I can sum up the differences as > additions of output parameters and assignments in the file od.sql.10. > > Calling the procedure in order_display.sql returns the expected > results. Calling the procedure in od.sql.10 also returns the expected > results in the additional output parameters, except the > output parameter > 'o_id' now returns a 0 (null?) value.
0 and NULL are different values. First of all: which values do your output-variables have if $RC <> 0 in any case? I do not see any initialization, any stop-code or anything else. How do you assure that your whole dbproc is done correctly ? I think, the list, not knowing of the data in your database cannot say if 0 is a correct result. Check the intermediate result (after first fetch), insert stop-code, insert initialization and you will be able to see what is going on. Elke _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
