Re: :Oracle unicode problem

2004-11-03 Thread Christian Merz
Hi, a few days ago I got a note dealing with character set problems (with German umlauts). (I didn't counter check the info) In a Windows environment you have to cope with at least 4 character sets. 1. internally WinNT uses UCS-2 (2 bytes) Win2000 uses UTF16 (2 or 4 bytes) 2. graphical apps may us

Re: Odd behavior -> it worked yesterday but not today

2004-11-03 Thread Jonathan Leffler
Start by reading this URL: http://www.catb.org/~esr/faqs/smart-questions.html What changed? Things like this don't break unless you change something... You rebooted. Rebooting can remove stuff from places like /tmp. Could that be a factor? What version of anything are you working with? What

need help capturing an error

2004-11-03 Thread Ian Harisay
Hi All, I have a query that when executed in sqlplus I get the oracle error ORA-02395: exceeded call limit IO usage. But when I execute the same query thru the DBI I am not capturing the error. $sth just doesn't have a result set and does not tell me oracle errored out. Thanks for any suggestio

RE: Cant' load Oracle.ppd

2004-11-03 Thread Jeff Urlwin
> > > Hello, > > > > I read some post about this problem to connect Oracle9: > > install_driver(Oracle) failed: Can't load > 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module > DBD::Oracle: load_file:The specified module could not be > found at C:/Perl/lib/DynaLoader.pm line 206. >

Cant' load Oracle.ppd

2004-11-03 Thread Pontiggia Ezio
Hello, I read some post about this problem to connect Oracle9: install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:/Perl/lib/DynaLoader.pm line 206. Compilation failed in require

RE: Re: RE: Perl Question:

2004-11-03 Thread bruce
sunil do me a favor... give me what you said in psuedo code... show me your logic in a rough code/logic flow.. thanks.. -bruce -Original Message- From: Sunil A.V. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 9:47 AM To: [EMAIL PROTECTED] Subject: Re: Re: RE: Perl Qu

Re: Re: RE: Perl Question:

2004-11-03 Thread Jeffrey . Seger
If I am undertanding this correctly, you have a 'not in' predicate which will have a varying number of elements from one execution to the next, right? Given that, I would construct an array of statement handles something like this: my @sth; while (){ my $num = scalar @arguments;

Re: Re: RE: Perl Question:

2004-11-03 Thread Sunil A.V.
Hi all, I have put this followup question to my previous question [might have been hidden in my previous email]. FOLLOWUP QUESTION: I have a data file with about 4 rows. Each row has a material name. I will have to fetch about 10 attributes depending on this material name. So I have 10 quer

RE: (Fwd) Question about DBI and LOB

2004-11-03 Thread Reidy, Ron
What is in your alert log (alertSID.log)? Did it generate a trace file? - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 10:24 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject

(Fwd) Question about DBI and LOB

2004-11-03 Thread Tim Bunce
- Forwarded message from Bruno Estrade <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] X-Pobox-Antispam: Require PTR Record returned DENY: 83.145.70.1 has no PTR record X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through 83.145.70.1) X-Pobox-Antispam: Bad HELO h

Re: free unreferenced scalar error

2004-11-03 Thread Tim Bunce
On Tue, Nov 02, 2004 at 03:41:49PM -0500, Marc M. Adkins wrote: > On Sunday 31 October 2004 10:06 am, Tim Bunce wrote: > > On Sat, Oct 30, 2004 at 10:23:46AM -0400, Marc M. Adkins wrote: > > > On Thursday 14 October 2004 05:20 am, Tim Bunce wrote: > > > > On Wed, Oct 13, 2004 at 04:33:14PM -0400, M

Re: OT: Congrats, Tim!

2004-11-03 Thread Tim Bunce
On Tue, Nov 02, 2004 at 02:04:30PM -0600, Jesse, Rich wrote: > ...on making Oracle Open Source Dev of the year: > > http://www.oracle.com/technology/oramag/oracle/04-nov/o64awards.html#BUNCE Thanks. (And to everyone else who's offered their congratulations.) I knew of the award a few months ago

RE: :Oracle unicode problem

2004-11-03 Thread prashant shelar
Hi, I already set NLS_LANG=.UTF8 in .bash_profile. The data I am reading from $file which is in UTF-8 format. If I do not use encode() function then the data inserted in the database is "inverted question mark" for any japanese character. If I ran the code without encode() function on windows 200