Home » SQL & PL/SQL » SQL & PL/SQL » Causes of internal code error :??
icon4.gif  Causes of internal code error :?? [message #216808] Tue, 30 January 2007 09:20 Go to next message
Messages: 74
Registered: October 2006
Location: Pakistan

hi all,
i write a cursor-procedure "Result_ballot".
it was working fine yesterday ,
but to day when i call it now.i got the following errors .


ERROR at line 1:
ORA-00600: internal error code, arguments: [rpidrv_1], [], [], [], [], [], [],

ORA-06512: at "ADMIN.RESULT_BALLOT", line ``
ORA-06512: at line 2

can some one explain me the causes of this errors.

Re: Causes of internal code error :?? [message #216809 is a reply to message #216808] Tue, 30 January 2007 09:37 Go to previous messageGo to next message
Messages: 381
Registered: September 2006
Location: UK
Senior Member
I can't see anything particularly odd in the procedure, apart from the fact that the inner PL/SQL block is redundant. What are the descriptions of the tables ? Do they have any strange data types in them ?

There will be a trace file generated as a result of the ORA-600. You should have a look at that to determine if it contains any further information. If necessary, you can send it to Oracle support.
Re: Causes of internal code error :?? [message #216874 is a reply to message #216808] Tue, 30 January 2007 14:22 Go to previous message
Messages: 508
Registered: March 2005
Senior Member
I don't know why it is failing, but this is what it should be

    INSERT INTO ballot_result
    SELECT ballot_dup.yr
    FROM member_master
    WHERE member_master.leader_no = ballot_dup.ldr_no;

Previous Topic: Table as Input Parameter (merged)
Next Topic: Index column name- where is it stored?
Goto Forum:

Current Time: Fri Aug 18 09:36:51 CDT 2017

Total time taken to generate the page: 0.06696 seconds