Stephen Lee,
Hi, in 8i etc, you can use
dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-02-10 14:09:00 ,you wrote£º=======
>You have to load it by running the dbmssupp.sql script in the ?/rdbms/admin
>directory.
>
>> -----Original Message-----
>> From: Igor Neyman [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, February 10, 2003 3:44 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Re: Bind variables
>>
>>
>> Stephen,
>>
>> What version of oracle are you talking about?
>> I didn't find dbms_support in 9.2.
>>
>> Igor Neyman, OCP DBA
>> [EMAIL PROTECTED]
>>
>>
>>
>> ----- Original Message -----
>> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
>> Sent: Monday, February 10, 2003 3:43 PM
>>
>>
>> >
>> > You might try playing around with the DBMS_SUPPORT package
>> which is loaded
>> > with the dbmssupp.sql script in the rdbms/admin directory.
>> >
>> > dbms_support.start_trace_in_session(SID, SERIAL#, waits=>false,
>> binds=>true)
>> >
>> > dbms_support.stop_trace_in_session(SID, SERIAL#).
>> >
>> >
>> >
>> > > -----Original Message-----
>> > >
>> > > It worked well from SQLplus but not from procedure.
>> > > Did I miss something ?
>> > >
>> > >
>> > --
>> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > --
>> > Author: Stephen Lee
>> > INET: [EMAIL PROTECTED]
>> >
>> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > San Diego, California -- Mailing list and web
>> hosting services
>> >
>> ---------------------------------------------------------------------
>> > To REMOVE yourself from this mailing list, send an E-Mail message
>> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> > the message BODY, include a line containing: UNSUB ORACLE-L
>> > (or the name of mailing list you want to be removed from). You may
>> > also send the HELP command for other information (like subscribing).
>> >
>> >
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Igor Neyman
>> INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Stephen Lee
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
