Seqval function does not work in Oracle 8.0.5.2.1 Steven Feuerstein sfeuerstein steven@stevenfeuerstein.com

Previous | Next

Topic: Seqval function does not work in Oracle 8.0.5.2.1
Conf: 537, Msg: 40077
From: Steven Feuerstein (steven@stevenfeuerstein.com)
Date: 12/16/00 08:36 AM

Seqval function does not work in Oracle 8.0.5.2.1 Steven Feuerstein sfeuerstein steven@stevenfeuerstein.com Hmmm. Sigh...this is a problem. To allow my generic utPLSQL.seqval function to work within SQL, I have to put a PRAGMA RESTRICT_REFERENCES on the function header. But I will not be able to do that since it uses DBMS_SQL. So it will take a bit of rewriting to change how sequence values are generated. My apologies!

SF