Re: Developer 6.0 - End of data on comm. channel

Thank you.

 Michael.

In article <38107A29.C2E1E301_at_t-online.de>,   Guenter Huerkamp <guenter-huerkamp_at_t-online.de> wrote:
> Hello Michael,
> i saw this answer on oracle-technet:
>
> i posted the problem also in the "Oracle Technical Forum".
> the answer from oracle is:
>
> "This is related to bug:966970. This is under
> resolution. There are no workarounds available as
> of now."
>
> in the meantime, i solve the problem not very elegantly:
> instead of using the plsql-table-parameter, i define a plsql-
> table-variable in the database (in a package header), fill the
> variable in a loop in forms (many network-roundtrips!) and call
> then the stored procedure without the parameter. the stored
> procedure then uses the data from the variable in the database.
>
> HTH
> Günter
>
> michael_bialik_at_my-deja.com schrieb:
>
> > Hi.
> >
> > I am trying to call stored procedure on server from
> > Developer 6.0 and passing PL/SQL table as parameter.
> > When the number of table's entries exceeds 55 - I always
> > get "END OF DATA ON COMMUNICATION CHANNEL" and my
> > Oracle connection breaks.
> > The same call work fine when performed on server with more
> > than 300 entries in the table.
> >
> > Anybody run into such problem?
> >
> > Michael.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 23 1999 - 23:34:58 CEST