Posted by gupta.harika on 03/01/06 14:20

Hi everyone,

I am a developer working on php with oracle as backend.
I am facing a problem related with the CLOB data.
The problem is as follows
My application uses a table which contains Clob datatype.
I need to do a search on this table based on the clob data,i.e., I am
using the column which is a clob datatype in the where clause.
The query is as follows
" select * from mytable where (dbms_lob.instr(mybody, 'as') > 0)"
If the result set has less records then the data gets displayed in the
front end page of the application...
If the result set contains more records and the query takes more that
30 seconds to execute in the backend the data does not get displayed in
the frontend page of the application.
I get an error telling
"Fatal error: Maximum execution time of 30 seconds exceeded."
Can any one of you please help me out in solving this problem.

Thanks in advance.

• Next in forum: how to print data on paper with header in each new page?
• Prev in forum: Re: Losing Session Variables in IE6
• Thread view: using clob in where clause

[Reply to this message]