Re: Problem with Oracle collections/objects

2011-12-21 Thread Martin J. Evans
On 21/12/11 13:16, Martin J. Evans wrote: On 21/12/11 13:05, Charles Jardine wrote: I think I have found the resource drain which causes your slow-down problem. Buffers implicitly allocated in the cache by OCIDefineObject() need to be deallocated explicitly by OCIObjectFree() 'when they are no

Re: Problem with Oracle collections/objects

2011-12-21 Thread Martin J. Evans
On 21/12/11 13:05, Charles Jardine wrote: On 12/12/11 20:24, Martin J. Evans wrote: On 12/12/2011 18:15, Charles Jardine wrote: On 12/12/11 16:13, Martin J. Evans wrote: On 09/12/11 18:02, Charles Jardine wrote: On 09/12/11 14:01, Martin J. Evans wrote: Hi, If anyone is around who wrote or

Re: Problem with Oracle collections/objects

2011-12-21 Thread Charles Jardine
On 12/12/11 20:24, Martin J. Evans wrote: > On 12/12/2011 18:15, Charles Jardine wrote: >> On 12/12/11 16:13, Martin J. Evans wrote: >>> On 09/12/11 18:02, Charles Jardine wrote: On 09/12/11 14:01, Martin J. Evans wrote: > Hi, > > If anyone is around who wrote or has worked on the

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
since it came out way back in >oracle 8 I will play a little more when I get some time and see if I can rewrite the code to not use the CAST and array Cheers John > From: byter...@hotmail.com > To: martin.ev...@easysoft.com; dbi-dev@perl.org > CC: dbi-us...@perl.org > Subj

RE: Problem with Oracle collections/objects

2011-12-13 Thread John Scoles
tin.ev...@easysoft.com; dbi-dev@perl.org > CC: dbi-us...@perl.org > Subject: RE: Problem with Oracle collections/objects > Date: Sun, 11 Dec 2011 12:00:12 -0500 > > > Well I wrote the code in DBD::Oracle for embedded objectes/types so I am the > one to blame for that. From the SQL and co

Re: Problem with Oracle collections/objects

2011-12-12 Thread Martin J. Evans
On 12/12/2011 18:15, Charles Jardine wrote: On 12/12/11 16:13, Martin J. Evans wrote: On 09/12/11 18:02, Charles Jardine wrote: On 09/12/11 14:01, Martin J. Evans wrote: Hi, If anyone is around who wrote or has worked on the object/collections support in DBD::Oracle I'd greatly appreciate it

Re: Problem with Oracle collections/objects

2011-12-12 Thread Charles Jardine
On 12/12/11 16:13, Martin J. Evans wrote: > On 09/12/11 18:02, Charles Jardine wrote: >> On 09/12/11 14:01, Martin J. Evans wrote: >>> Hi, >>> >>> If anyone is around who wrote or has worked on the object/collections >>> support in DBD::Oracle I'd greatly appreciate it if you could take a >>> quick

Re: Problem with Oracle collections/objects

2011-12-12 Thread Martin J. Evans
On 09/12/11 18:02, Charles Jardine wrote: On 09/12/11 14:01, Martin J. Evans wrote: Hi, If anyone is around who wrote or has worked on the object/collections support in DBD::Oracle I'd greatly appreciate it if you could take a quick look at this problem as the code in DBD::Oracle for this has d

RE: Problem with Oracle collections/objects

2011-12-11 Thread John Scoles
Well I wrote the code in DBD::Oracle for embedded objectes/types so I am the one to blame for that. From the SQL and connection string below looks like you are using the Oralce sql extensions to get the data back and not the native DBD::Oracle/OCI object selections so we might be looking at so

Re: Problem with Oracle collections/objects

2011-12-09 Thread Martin J. Evans
On 09/12/2011 18:02, Charles Jardine wrote: On 09/12/11 14:01, Martin J. Evans wrote: Hi, If anyone is around who wrote or has worked on the object/collections support in DBD::Oracle I'd greatly appreciate it if you could take a quick look at this problem as the code in DBD::Oracle for this has

Re: Problem with Oracle collections/objects

2011-12-09 Thread Charles Jardine
On 09/12/11 14:01, Martin J. Evans wrote: > Hi, > > If anyone is around who wrote or has worked on the object/collections > support in DBD::Oracle I'd greatly appreciate it if you could take a > quick look at this problem as the code in DBD::Oracle for this has > defeated me so far. > > The probl