Re: CF / Oracle Error : maximum cursors

2004-11-11 Thread Douglas Knudsen
We turned off 'maintain connections' for the DSN for this app and bamm! workie works! Doug On Thu, 11 Nov 2004 07:53:39 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > Well maybe the problem is with Oracle but the root of it isnt Oracle.. > it's something with the way CF builds those queries a

Re: CF / Oracle Error : maximum cursors

2004-11-11 Thread Greg Morphis
Well maybe the problem is with Oracle but the root of it isnt Oracle.. it's something with the way CF builds those queries and loads those files. On Thu, 11 Nov 2004 07:48:11 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > The problem isnt with Oracle.. I wrote 2 non-dynamic queries and > upload

Re: CF / Oracle Error : maximum cursors

2004-11-11 Thread Greg Morphis
The problem isnt with Oracle.. I wrote 2 non-dynamic queries and uploaded several documents in a row. So it has to be within the query and the building of the dynamic query structure. On Thu, 11 Nov 2004 07:07:20 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > I've got an upload utility I'm usin

CF / Oracle Error : maximum cursors

2004-11-11 Thread Greg Morphis
I've got an upload utility I'm using to allow the client to upload a txt file which could go into 1 of 33 different tables.. the reports are structured so differently it's impossible to put them all into one table. After uploading the first document (304 rows), I try to upload another this one has