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.
Jean Sagi — — source: Usenet: comp.databases.informix
How are you returning from sp_Test2() ?
J.
-----Original Message-----
From: agustincb <agustincb.26v990@no-mx.forums.yourdomain.com.au>
To: informix-list@iiug.org
Date: Wed, 26 Apr 2006 05:53:48 -0400
Subject: Errors in stored procedure don't raise
Hi, i'm using the IBM Informix ODBC driver v. 2.90 to connect to a
informix server. I have this two test procedures; the only difference
is that the second returns a value:
CREATE PROCEDURE sp_Test1()DEFINE X INTEGER;
LET X = 0/0;
END PROCEDURE
CREATE PROCEDURE sp_Test2() RETURNING INTEGERDEFINE X INTEGER;
LET X = 0/0;
END PROCEDURE
execute procedure sp_test1() -> Fails, as expected "Attempt to divideby 0"
execute procedure sp_test2() -> This doesn't fail, it raises no
error, it just returns no rowsThe same happens if i do
SELECT sp_test2() FROM systables WHERE tabid = 1
If i call the procedures from isql it behaves ok, I mean it raises the
error in both cases
Any tips?
--
agustincb
------------------------------------------------------------------------
agustincb's Profile: http://www.dbtalk.net/m129
View this thread: http://www.dbtalk.net/t302308
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Jean Sagi
jeansagi@myrealbox.com
jeansagi@gmail.com
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.