Previous | Next
Topic: Seqval function does not work in Oracle 184.108.40.206.1
Conf: 537, Msg: 39964
From: Tom Szidon (email@example.com)
Date: 12/13/00 06:55 AM
Seqval function does not work in Oracle 220.127.116.11.1 Tom Szidon szidon firstname.lastname@example.org
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?