Re: SHOW ERRORS not working

Hi Dave

I have had the same issue before but i don't remember the answer but I think i found it with either trace or SQL*Net trace.

I think show is a keyword implemented in SQL*Plus that simply translates into some SQL. Set trace on your session and on your users session and use tkprof with SYS = yes to collect all SQL including ddl and see if a difference is shown between your session and his, you in theory should have the same SQL as him but it could indicate where the difference lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you should see the SQL used in the packet contents.

hope this helps

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.