Re: sql_trace parameter

Lisa,
the false is incorrect, you can modify it on the session level.
maybe this is a bug
Alessandro Guimaraes

 From: Regina Harter <rharter_at_emc-inc.com>  Date: Mon, 08 Jan 2001 13:17:35 -0800
 Subject: RE: Date comparison question

At 12:32 PM 1/8/01 -0800, you wrote:
>Because, by default date fields do not return the TIME portion unless
>specifically requested to. So you check against run_date has no time
>portion so a match is not possible.

Sorry, but this is untrue. We have run into this many times. Even though the default date format for displaying dates does not include time, if a date field contains a time, it will still use the time portion when comparing it to another date.

>-----Original Message-----
>From: Lisa Yates [SMTP:cosnit_at_creighton.edu]
>Sent: Monday, January 08, 2001 2:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Date comparison question
>
>
>Why doesn't this query ever return...
>
>where run_date = to_date('01-03-2001 16:34:59','mm-dd-yyyy hh24:mi:ss')
>
>but this query does....
>
>where to_char(run_date) = to_char(to_date('01-03-2001
>16:34:59','mm-dd-yyyy hh24:mi:ss'))
>
>and so does this query....
>
>where to_char(run_date,'mm-dd-yyyy hh24:mi:ss') = '01-03-2001 16:34:59'
>
>?
>
>TIA
>
>Lisa
>
>
>********************************************
>* Lisa Yates cosnit_at_creighton.edu *
>* Creighton University *
>* Omaha, Nebraska *
>* (402) 280-2419 fax: (402) 280-2573 *
>* Define the Universe, give 2 examples. *
>********************************************
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Lisa Yates
> INET: cosnit_at_creighton.edu
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: William Rogge
> INET: William_Rogge_at_voltek.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).

 From: Dwayne Cox <dcox_at_eng.ufl.edu>
 Date: Mon, 8 Jan 2001 16:32:54 -0500 (EST)  Subject: Off topic: DBD::Oracle

For the life of me, I cannot seem to get DBD::Oracle to work. The 'make test' portion of the install hangs every time. Using DBI 1.13 and DBD 1.02, it does not hang until it gets to the repetitive connection stage but it still hangs. Later versions and combinations hang earlier.

FYI: The DBI mods install flawlessly. And I remember to delete the old versions of both the DBD and DBI before trying a new/different version.

Would someone kindly point me in the right direction to solve this problem? I was unable to find a solution on technet or deja.

Platform: RedHat 6.2 (with various security patches), Oracle 8.1.6, Perl Received on Mon Jan 08 2001 - 14:08:13 CST