Re: RE: Bind variables

Stephen Lee,

                Hi, in 8i etc, you can use dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too.

Regards
zhu chao
msn:chao_ping_at_163.com
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:ineyman_at_perceptron.com]
>> 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
>> ineyman_at_perceptron.com
>>
>>
>>
>> ----- Original Message -----
>> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> 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: Stephen.Lee_at_DTAG.Com
>> >
>> > 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: ListGuru_at_fatcity.com (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: ineyman_at_perceptron.com
>>
>> 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: ListGuru_at_fatcity.com (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: Stephen.Lee_at_DTAG.Com
>
>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: ListGuru_at_fatcity.com (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: chao_ping_at_vip.163.com

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: ListGuru_at_fatcity.com (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).