Jump to content

ORA-00600: internal code error

Recommended Posts

i just want to execute this in oracle form 6i but it will give me an error like ORA-00600: internal code error


   stock_price NUMBER := 9.73;
   net_earnings NUMBER := 0;
   pe_ratio NUMBER;
-- Calculation might cause division-by-zero error.
   pe_ratio := stock_price / net_earnings;
   DBMS_OUTPUT.PUT_LINE('Price/earnings ratio = ' || pe_ratio);
EXCEPTION  -- exception handlers begin
-- Only one of the WHEN blocks is executed.
   WHEN ZERO_DIVIDE THEN  -- handles 'division by zero' error
      DBMS_OUTPUT.PUT_LINE('Company must have had zero earnings.');
      pe_ratio := NULL;
   WHEN OTHERS THEN  -- handles all other errors
      DBMS_OUTPUT.PUT_LINE('Some other kind of error occurred.');
      pe_ratio := NULL;
END;  -- exception handlers and block end here


Share this post

Link to post
Share on other sites

Hi Amir, and welcome to the forum!

Can you post the whole error message, including the sub-codes?

The ora-600 errors are internal problems that require opening a SR on MOSC;


MOSC also has a handy ORA-600 lookup tool, where you enter the sub-codes for the error.

Please read carefully:


Good luck!

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now