Re: No data returned from linked database

2008-09-12 Thread Bruce Johnson
On Sep 12, 2008, at 5:18 AM, [EMAIL PROTECTED] wrote: I would first check you NLS settings me thinks this is what is causeing the problems and see if you can get 1.17 working with then the later DBD::Oracles will work. More detailed information on my NLS settings, this is the standard

Re: No data returned from linked database

2008-09-12 Thread scoles
Well reviewed the output of you trace and I noticed this with the 8 client OCIInitialize(2,0,0,0,0)=SUCCESS OCIEnvInit(814ab98,0,0,0)=SUCCESS OCIHandleAlloc(826e0a8,814ab9c,OCI_HTYPE_ERROR,0,0)=SUCCESS is used to create the enviornment while whith the 10 client OCINlsEnvironmentVariableGet(1,

Re: No data returned from linked database

2008-09-11 Thread John Scoles
Thanks Bruce I will have a look at this if not today then Tomorrow as I am busy with 'real' :-( work these days. Cheers John Scoles Bruce Johnson wrote: On Sep 10, 2008, at 4:14 AM, John Scoles wrote: If you can set up a small Perl script that you know works in the old system and then set t

Re: No data returned from linked database

2008-09-10 Thread Bruce Johnson
On Sep 10, 2008, at 4:14 AM, John Scoles wrote: If you can set up a small Perl script that you know works in the old system and then set the debug level to at least 6 next if you can run the same script on your new location If you can send the output to the list we might be able to see what

Re: No data returned from linked database

2008-09-10 Thread Douglas Wilson
On Wed, Sep 10, 2008 at 9:53 AM, Bruce Johnson <[EMAIL PROTECTED]> wrote: > > On Sep 10, 2008, at 4:14 AM, John Scoles wrote: > >> Well that is a head scratcher. It will be hard to replicate this error so >> look like you will have to do the debugging for us. >> >> If you can set up a small Perl s

Re: No data returned from linked database

2008-09-10 Thread Bruce Johnson
On Sep 10, 2008, at 4:14 AM, John Scoles wrote: Well that is a head scratcher. It will be hard to replicate this error so look like you will have to do the debugging for us. If you can set up a small Perl script that you know works in the old system and then set the debug level to at leas

Re: No data returned from linked database

2008-09-10 Thread John Scoles
Well that is a head scratcher. It will be hard to replicate this error so look like you will have to do the debugging for us. If you can set up a small Perl script that you know works in the old system and then set the debug level to at least 6 next if you can run the same script on your new

No data returned from linked database

2008-09-09 Thread Bruce Johnson
I've been banging my head against the wall for two weeks now on this one. I'm desperately trying to update my existing production system (Oracle 8.1.7, DBD::Oracle 1.14, on a system with a dying RAID controller) to a new system running a current version of Oracle. and have run into a real