Re: ORA-03113 in intermedia

From: Jason Pepper <jason.pepper_at_oracle.com>
Date: Fri, 26 Jul 2002 23:50:30 +0100
Message-ID: <3sk09.24$dL.171@news.oracle.com>

try using ctx_output.start_log and ctx_output.end_log to wrap your query (look them up in the doc for more info)

these should write you a log file that will tell you precisely what the INSO filters were doing when the 3113 occurred.

take it from there and follow up with support, they'll thank you for the extra info

-JP

"Angel Faus" <afaus_at_corp.vlex.com> wrote in message news:7a7a07a.0207260143.4332f422_at_posting.google.com...
> Hi,
>
> I've got an application that uses an intermedia text query (contains
> (..) > 0).
>
> The application works normally well, but for some queries I get a
> ORA-03113 error [end-of-file on communication channel].
>
> I think it is related to the query returning a very large number or
> elements:
> is there any configuration parameter (a buffer size, a timeout, ..? )
> that can be changed to fix this kind of problems?
>
> Any help would be really apreciated,
>
> -àngel
> afaus_at_corp.vlex.com
Received on Fri Jul 26 2002 - 17:50:30 CDT