Jump to content
AAMIR413

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

 

DECLARE
   stock_price NUMBER := 9.73;
   net_earnings NUMBER := 0;
   pe_ratio NUMBER;
BEGIN
-- 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;

http://support.oracle.com

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

Please read carefully:

http://www.dba-oracle.com/oracle_tips_ora_600.htm

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

×