[Info-ingres] Using a sequence to supply a DBP argument

[Martin Bowes]

Hi Roy,

I just tried a variation:

execute procedure echo_int(test_seq.next)\g           
Executing . . .

E_US0986 Invalid correlation or column name 'test_seq' in EXECUTE
    PROCEDURE statement. Column expressions of the form [table.]column are not
    allowed in the target list.
    (Fri Jan  5 13:37:45 2018)

And I also get the same error when I name the parameter.

As to whether or not you should be able to do it ... I'd go with a yes.

Marty

-----Original Message-----
From: Roy Hann [mailto:specially at processed.almost.meat] 
Sent: 05 January 2018 12:55
To: info-ingres at lists.planetingres.org
Subject: [Info-ingres] Using a sequence to supply a DBP argument

Assuming the myproc procedure and myseq sequence are defined correctly and the types match, should I be able to do this?

  execute procedure myproc ( next value for myseq );

Obviously in a moral sense I "should" be able to do this. But when I tried it just now I got an E_OP0681 consistency check. (That suggests the syntax palatable...)

Roy


_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres