ORA-00904: TABLE_SCHEMA : INVALID IDENTIFIER - Under DBA-Export Jobs

(Doc ID 2307453.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle SQL Developer - Version 17.2 and later
Information in this document applies to any platform.

Symptoms

DBA Functions (like User Mgmt)

SQL Developer v17.2 refers to an incorrect column while trying to display Export DATAPUMP job status in DBA menu tree.

The following error is being displayed:

CHECKING MASTER TABLE
  
Error starting at line : 13 in command -
DECLARE
  mycount NUMBER:=0;
  JOB_STATE varchar2(1000):='&&job_state';
BEGIN
  :UTL_ERROR :=NULL;
  SELECT COUNT(*)
  INTO mycount
  FROM Dba_tab_privs
  WHERE table_name ='UTL_FILE'
  AND privilege ='EXECUTE'
  AND table_schema ='SYS';
  IF (mycount =0) THEN
  raise NO_DATA_FOUND;
  END IF;
  IF ((JOB_STATE IS NULL) OR (JOB_STATE!='NOT RUNNING')) THEN
  :UTL_ERROR:='STATE IS NOT ''NOT RUNNING''';
  END IF;
EXCEPTION
WHEN no_data_found THEN
  :UTL_ERROR:='NO EXECUTE ON SYS.UTL_FILE';
END;
Error report -
ORA-06550: line 11, column 7:
PL/SQL: ORA-00904: "TABLE_SCHEMA": invalid identifier
ORA-06550: line 6, column 3:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:




Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms