Re: ORA-12838 error on a stored procedure

From: DVD <billi.david_at_gmail.com>
Date: 27 Mar 2007 03:55:06 -0700
Message-ID: <1174992906.821497.51520@n76g2000hsh.googlegroups.com>

> Just a wild guess. If possible try to give a COMMIT after INSERT INTO
> NAMES.... part.
> let us know if that helps.- Nascondi testo tra virgolette -

Hi,
unfortunately I've some problems with development environment, so I can't try now it.

Do you think that COMMIT is a solution?

I add an information about queries, that are:

INSERT /*+ NOAPPEND NOPARALLEL */ INTO NAMES (...) SELECT /*+ NOPARALLEL(t) */ ... FROM TEMP ... WHERE ROWID = row_id (i)
DELETE /*+ NOPARALLEL */ ... FROM TEMP WHERE ROWID = row_id (i)

Thank you for support. Received on Tue Mar 27 2007 - 05:55:06 CDT