Re: Urgent Please Ora-00604

In article <86albr$n34$1_at_nnrp1.deja.com>,

        ruku_at_my-deja.com writes:
>
> I'm trying to execute a stored procedure and get the errors
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01400: cannot insert NULL into ("SYS"."OBJ$"."NAME")

Some statement you executed caused a record to be inserted into SYS.OBJ$, which has a record for every object in the database. This means you tried to create an object. Apparently, somehow the object you tried to create has a NULL name. This should of course not happen. Check your code.

> The procedure runs with compilation errors and then I try to fix one
> variable whose declaration is not correct. I get this error when I fix
> the variable. If I just leave the variable the procedure runs with
> compilation errors. What should I do get over this proble. My time is
> really tight . Could anybody there help me.

Fix the errors. Don't only fix anything the compiler complains about, but also check if your code really does what it's supposed to do. If you want to get more help, show some code.

Remco
--
rd1936: 12:25am up 13 days, 5:04, 8 users, load average: 1.53, 1.54, 1.54 Received on Fri Jan 21 2000 - 17:58:08 CST