Thanks John,

Some sod has previously run the DBMS_SUPPORT and DBMS_SYSTEM
package script as my user, so it's trying to call that. I exec'd
sys.dbms_support to set binds on and waits off, and it worked.

Thanks for the help. Going to clear out my users schema now.

Cheers

Gary

-----Original Message-----
From: john
[mailto:oracledba-ezmlmshield-x56696543.[Email address protected]
Sent: 08 October 2004 07:59
To: LazyDBA Discussion
Subject: RE: Setting 10046


Look at DBMS_SYSTEM and DBMS_SUPPORT
I think one of these doesn't support level of trace though which you
need to set
in order to see bind variables.

John

________________________________

From: Gary Colbran (GJ) [mailto:oracledba-ezmlmshield-x82246431.[Email
address protected]
Sent: Fri 08/10/2004 07:38
To: LazyDBA Discussion
Subject: Setting 10046




Hi,

I need to set trace on a session to see the bind variables,
but get the error ORA-06509, ICD Vector missing. I've checked on the
web and it suggests to run CATALOG and CATPROC, stating that they may
have been run as a user other than sys. I cannot run these on the live
system at the moment, so what is the best option to fix the problem,
or another way to set 10046 on another users session ?

Cheers

Gary

==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at

http://www.telkom.co.za/TelkomEMailLegalNotice.PDF


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, please notify the sender immediately and
delete the original. Any other use of the email by you is prohibited.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF

Oracle LazyDBA home page