BUG: function restarting over and over?

[jamoss]

I have a function that contains multiple complicated queries in it (ORACLE 8i).

The number of times it runs these queries is variable.

Problem is, if there are more than, say, 300 queries, somehow the function is recycling-- starting over. It times out (or something) and then the procedure (function) starts again from the beginning.

Is this a PHP problem? Or is Oracle bombing out?

I have never experienced PHP recycling like this.

Thanks for any insight!

[ScubaKing22]

Could you please post your code? That will allow us to easier understand and correct the problem.

[jamoss]

Can't do that (proprietary), but I can explain the function:

It is a data (like job applications) that pulls from many different tables. When I include cover letters it bombs and keeps restarting. When I remove the cover letter as a field to query, it works fine. If I do just the cover letters, it works fine.

I am saving the query results into an array. SO, all I can think of is that it's running out of memory -- or conflicting with the function that is in memory. So it starts over again.

😕