ORA-22275: invalid LOB locator specified - when executing as script from Toad

Toad for Oracle & DevOps Toolkit
1

If I issue the Below statement (execute as a script)

select * from dba_priv_audit_opts

I receive the below message (however data does return)

ORA-02002: error while writing to audit trail

ORA-22275: invalid LOB locator specified

If I just hit “EXECUTE” it works fine.

Thanks,

2

I don’t think this has anything to do with Toad.

I’ll bet if you just hit “Execute” and then scroll to the end, you’ll get the same message. I think you will also see the same thing if you run that in SQL*Plus. Something is going on in the database.