Nikolaos Vogiatzis wrote: > > hi all... > > just a quick question if i may... > > i have created a dbproc, no probs, but when i try and call it > from SQL studio, > it complains... > > the dbproc definition is: > CREATE DBPROC TSC_UTIL_DETECTVOL (IN OWNER FIXED(10,0), IN > REGION FIXED(10,0)) > AS > > below are the input/output... > > thanks in advance for your help... > > cheers > nik > > ============== > CALL tsc_util_detectvol(2,1) > > ---- Error ------------------------------- > > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > > Integrity constraint violation;200 POS(1) unexpected error. > > CALL tsc_util_detectvol(2,1) > > =================== > the 200 seems to be error 200, duplicate key, which will arise if you try to insert a row with a primary key into a table where this primary key exists before.
The text Integrity constraint violation (not belonging to error 200, some typing error??) tells us, that you tried to insert/update a row/column with a value not satisfying the constraints (NOT NULL, CHECK,..) defined for this table/column. Because we do not know your table definition and do not know the dbproc, we cannot help any further. If this info does not help to find the reason, include some additional stop-statements with specific text/errornos into you dbproc to see which statement causes the problem. Elke SAP Labs Berlin > > _____ > > > Nikolaos Vogiatzis > BSc (Ma & CompSc)(Adel) MAPESMA AACS > PhD Candidate > Secretary, International Project for the Integration of > Transportation Systems > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.680 / Virus Database: 442 - Release Date: 9/05/2004 > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
