Skip to content

Instantly share code, notes, and snippets.

@nervouswiggles

nervouswiggles/406_OIM See 'blob as text' from the ERROR_DATA column within JOB_HISTORY table

Created August 9, 2015 12:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nervouswiggles/f7577f661533ba2fea49 to your computer and use it in GitHub Desktop.
Save nervouswiggles/f7577f661533ba2fea49 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
406_OIM See 'blob as text' from the ERROR_DATA column within JOB_HISTORY table
select utl_raw.cast_to_varchar2(DBMS_lob.substr(ERROR_DATA)) from JOB_HISTORY where job_name = 'ADD_YOUR_SCHEDULED_TASK_NAME_HERE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment