Norbert Felde wrote : >Hello, > >I wrote the dbproc as follows. I can create it and call it without any >error message, but it dous not insert any data into the table. >Could you >tell me what is wrong in the proc. > >thank you advance, >Norbert > >the proc: > >CREATE DBPROC DATA_UJ ( > IN TABLEIDX varchar(4), > IN HEADERID integer, > IN PARAMID integer, > IN ERTEK varchar(100) > ) > RETURNS CURSOR AS > VAR DID integer; IQ varchar(500); > $CURSOR = 'DATA_CUR'; > TRY > SELECT SEQ_DATAID.NEXTVAL FROM DBA.DUAL; > FETCH INTO :DID; > SET IQ = 'INSERT INTO DNUSER.DATA' || TABLEIDX || > '( DATAID, HEADERID, PARAMID, ERTEK )' || > 'VALUES( ' || DID || ', ' || HEADERID ||', '|| PARAMID >||', '''|| ERTEK || ''')'; > EXECUTE IQ; > DECLARE :$CURSOR CURSOR FOR > SELECT :DID AS RES FROM DBA.DUAL; > CATCH > IF( $RC <> 0 ) > THEN STOP ( $RC, $ERRMSG ); > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > >
I tried to reproduce the problem, unfortunately without success. After a call of the procedure a row is inserted into the table DATAXXX. How did you verify that no insert has been executed ? Is it possible that you didn't commit the transaction containing the dbproc call ? If you are sure that a row must have been inserted but is not present in the table please send me a vtrace of the dbproc call. For vtrace please see http://sapdb.2scale.net/moin.cgi/VTrace Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
