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

Hello Michael,
[Quoted] 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- -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.
Received on Fri Oct 22 1999 - 16:52:25 CEST