Re: ORA-12838 error on a stored procedure

> 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 Received on Thu Mar 22 2007 - 05:38:02 CDT