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
