Re: CLOB select with ora_pers_lob (truncation issue)

2010-04-21 Thread Peter J. Holzer
On 2010-04-20 09:50:48 -0400, Martin Gainty wrote: some confusion on the oracle documentation http://www.scribd.com/doc/21329014/Oracle10g-Develop-PLSQL-Program-Units-VOL2 which states CLOB Datatypes is for single byte character stream NCLOB is multibyte character stream based upon byte

Re: Help on using on *nix and Windows

2010-04-21 Thread Jared Still
On Mon, Apr 19, 2010 at 5:39 AM, newbie01 perl newbie01.p...@gmail.comwrote: Hi Peter, Thanks to your response. Send to the DBI user group as this group is more likely to know about what sqlplus may be. Using sqlplus from within Perl is always an ugly proposition. I've done, others have

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
I am rebuilding my DBD installation on server A (the one where Oracle Wallet didn't work) I set my environment for oracle 10g, then did the install again. I have wallet working, but every time I run a script I get two copies of a dld.sl error for libclntsh.sl.10.1 I think I can live with that

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
I wasn't too clear. The scripts give error message complaints, but they actually do work. Chris -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Wednesday, April 21, 2010 12:39 PM To: John Scoles Cc: John Scoles; dbi-users@perl.org Subject: RE: Problems with

Re: Problems with external password store.

2010-04-21 Thread John Scoles
Howard, Chris wrote: Can you send the error message just for fun. Cheers John I wasn't too clear. The scripts give error message complaints, but they actually do work. Chris -Original Message- From: Howard, Chris [mailto:howa...@prpa.org] Sent: Wednesday, April 21, 2010 12:39

RE: Problems with external password store.

2010-04-21 Thread Howard, Chris
My script attaches to the database then does a query of sysdate from dual. Error shl_load failed for: libclntsh.sl.10.1, [errno 2: No such file or directory] /usr/lib/dld.sl: Can't open shared library: libclntsh.sl.10.1 /usr/lib/dld.sl: No such file or directory Error shl_load failed for: