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.
Hi community!
IDS 9.40.TC6
CREATE TABLE t1 ( f NVARCHAR( 10 ) );
CREATE TABLE t2 ( f NVARCHAR( 10 ) NOT NULL );
CREATE PROCEDURE p( p CHAR( 10 ) ) END PROCEDURE;EXECUTE PROCEDURE p( ( SELECT f FROM t2 ) );-- Oops! SQL Error (-674) : Routine (p) can not be resolved.
But if the folowed SQL will be executed first:
EXECUTE PROCEDURE p( ( SELECT f FROM t1 ) );then the problematic statement also works properly. Funny?
Any comments awaiting...
--
'''''''''' '''''''' '''' '''''''''''' http://pasts.delfi.lv
sending to informix-list
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.