Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
I try to make a stored procedure with an insert-statement:
CREATE PROCEDURE sqtest ()
RETURNING INTEGER; DEFINE int_t INTEGER;
SET DEBUG FILE TO "/tmp/debug.log";
TRACE ON;
Insert INTO seq1(dummy) VALUES ('1'); LET int_t = DBINFO('sqlca.sqlerrd1');
RETURN int_t;
END PROCEDURE
The table seq1 contains only 2 rows:
'key' as serial
'dummy' as CHAR(1)
If I call the procedure, I get
675: Illegal SQL statement in stored procedure.
the debugfile says:
insert into seq1(dummy)
values ("1");exception : looking for handler
SQL error = -675 ISAM error = 0 error string = = ""exception : no appropriate handler
I don' know, what's wrong :-(
I use Informix Dynamic Server, Linux Edition 7.30.UC7
Hagen
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.