oracle -20000,ORA-20000

ORA-20000: %s

Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated.[@more@]

ORA-20000: %s

Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated.

Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information.

解决方法

--DBMS_OUTPUT.PUT_LINE(length(v_msg_details));

DBMS_OUTPUT.put_line('details' || substr(v_msg_details, 0, 240));

DBMS_OUTPUT.put_line(substr(v_msg_details, 240, length(v_msg_details)));

DBMS_OUTPUT.put_line('count number: ' || v_message_count);