Previous | Next
Topic: Seqval function does not work in Oracle 8.0.5.2.1
Conf: 537, Msg: 39964
From: Tom Szidon (ext1tgs@ups.com)
Date: 12/13/00 06:55 AM
Seqval function does not work in Oracle 8.0.5.2.1 Tom Szidon szidon ext1tgs@ups.com
Attempting to add a a suite via "utSuite.add ('PLVision');" fails with the error: ORA-06571: Function SEQVAL does not guarantee not to update database.
We have determined this to be a conflict with dbms.sql and the pragma violation of calling a function which updates the database.
Our solution was to replace the SEQVAL function in utPLSQL with a procedure with an output parameter.
Has anyone faced this problem? Is there a better solution than ours?
TIA,
Tom Szidon