I am migrating an application from MySQL to Oracle 8 (not my choice to use Oracle) and have run into the following situation:
As part of the application, I create an HTML file on disk that contains information from the database. I am finding that if I fetch more than just a few rows of data from oralce (using ocifetchinto() ), the file is not built fast enogh to be loaded. I get the browser's 'cannot load page error' type of message.
If I slow things down in my code, by adding some echo's here and there to trace what's going on, it seems to give the application time to complete building the file. Thus my suspicion that it is a timing problem.
This technique worked fine with MySQL as the database, but not with oracle.
Does anyone know of a way to address what I think is a timing issue between when my code is trying to access the file, and when the file is available? I've thought about testing with fopen() to see if the file already exists (and loop until it does), but I'm replacing an existing file with the same name, so it might find the old one.
Any ideas?
ruski
