Re: urgent

[Danisment Gazi Unal]

Hello, Check alert.log. If there is a related error or if a trace is generated, forward them to list.     Big Planet wrote: Hi Guys ,I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection )  the connection drops  saying end-of-file on communication channel .This is happening after I executes the proc may be 10-12 times . One more thing ..one of parameter to the proc which is getting used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok. Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com