Matthias Juchem wrote :

>When calling a DBPROC (which does INSERTs), I get an error 360 (roreign key integrity 
>violation). But there is no hint >_which_ constraint have got violated. 

>When doing INSERTs (not in a DBPROC) and violating a constraint, I usually get the 
>name of the violated constraint.

>Is there a way to get more information what went wrong?

the system variable $ERRMSG should contain the message you received from the insert 
statement. 
if you stop the DBPROC via

STOP($rc, $errmsg)

after the insert error occurred, this message should be returned to the caller of the 
DBPROC.

Thomas

-- 
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to