ORA-30076: invalid extract field for extract source

ORA-30076: invalid extract field for extract source

Oracle PL/SQL error message: ORA-30076: invalid extract field for extract source.

Cause:

The extract source does not contain the specified extract field.

Solution:

Specify a valid extract field for the extract source.

Example 1:

SELECT EXTRACT (HOUR FROM SYSDATE) FROM DUAL;

Output:

ORA-30076: invalid extract field for extract source




Correct:

SELECT EXTRACT (HOUR FROM SYSTIMESTAMP) FROM DUAL;

Output:

11