Skip to Content
Former Member
Jun 29, 2016 at 03:06 PM

Debug XSoData Create using Stored Procedure



I've created an xsodata file in which I have one entity that is defined like below.

The stored procedure is used to update one or more fields from a record in a table, based on one key field.

If you would see something that is not done, please correct me.

As you can see I'm using an importing record and not individual variables, which are being read in the script.

When testing the POST service using postman i'm getting a 201 (created) return but this seems to be a lie when I check the DB afterwards.

What I would like to learn as a result of this post is how to debug the stored procedure using the debug configuration below.

And how to debug the procedure by testing the post operation using POSTMAN (or a similar tool).


I checked all the settings based on other SCN posts, debugger active in system, rights have been added, breakpoints are active in procedure,...

Please don't reply with the standard answers as I did my research.


Note: Another concern I have is how we can handle deep entity inserts using XS OData, is it possible or do you have to 'force' the UI developer to use batch requests ? It used to be possible in ABAP to write your own logic for deep inserts.

Thanks very much in Advance!!


pastedImage_0.png (13.7 kB)
pastedImage_1.png (36.9 kB)
pastedImage_4.png (31.5 kB)
pastedImage_5.png (12.0 kB)
pastedImage_7.png (25.5 kB)
pastedImage_8.png (14.3 kB)