Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-12838 error on a stored procedure
On Mar 22, 3:38 pm, "DVD" <billi.da..._at_gmail.com> wrote:
> > The procedure you posted is incorrect.
> > One single rowid won't occur in two tables ever.
>
> I don't understand if you talk about these steps:
>
> 1) INSERT INTO NAMES ... WHERE ROWID = row_id (i)
>
> 2) DELETE FROM TEMP WHERE ROWID = row_id (i)
>
> Because in fact them are:
>
> 1) INSERT INTO NAMES (...) SELECT (...) FROM TEMP WHERE ROWID =
> row_id (i)
>
> 2) DELETE FROM TEMP WHERE ROWID = row_id (i)
>
> Thanks
Just a wild guess. If possible try to give a COMMIT after INSERT INTO
NAMES.... part.
let us know if that helps.
Received on Sat Mar 24 2007 - 08:35:46 CDT