Toad World® Forums

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

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,

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.