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) =================== _____ 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
