simple problem with procedure.
Hi DBAs
I have a question i really appreciate your fast response
when i create very simple procedure via toad i receive below error while debugging :
CREATE OR REPLACE PROCEDURE test102
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('test1');
DBMS_OUTPUT.PUT_LINE('test 2');
END;
error message:
ORA-29532:JAVA CALL TERMINATED BY UNCAUGHT JAVA EXCEPTION:
java.lang.ArithmeticException:/ by zero
ORA-06512:at "SYS.DBMS_JAVA",line 124
ORA-06512:at line 1
we have not patched database after it has became production.
do i need to have other permissions?
also i have read <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;}
when i create very simple procedure via toad i receive below error while debugging :
CREATE OR REPLACE PROCEDURE test102
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('test1');
DBMS_OUTPUT.PUT_LINE('test 2');
END;
error message:
ORA-29532:JAVA CALL TERMINATED BY UNCAUGHT JAVA EXCEPTION:
java.lang.ArithmeticException:/ by zero
ORA-06512:at "SYS.DBMS_JAVA",line 124
ORA-06512:at line 1
we have not patched database after it has became production.
do i need to have other permissions?
also i have read <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;}
0