SQL Developer (MOSC)

MOSC Banner

Getting ORA-20001: STATE IS NULL, ORA-06512: while running Data Pump from SQL Developer

in SQL Developer (MOSC) 2 commentsAnswered ✓

Oracle Database Version: Oracle19c (v.19.33)

SQL Developer Version:  22.2.0.173


Getting the following error while trying to export user schemas with the Data Pump Export Jobs Wizard::

Error starting at line : 31 in command -

BEGIN

 IF (:UTL_ERROR IS NOT NULL) THEN

  Raise_application_error(-20001,:UTL_ERROR);

 END IF;

END;

Error report -

ORA-20001: STATE IS NULL

ORA-06512: at line 3


Thanks for your help!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center