SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL table

303302Oct 30 2003 — edited Oct 31 2003

Hello,
I have some problems with PL/SQL code in a Package Body in Forms 6i(6.0.8.23.2).

I have defined PL/SQL table like this:

type TextData is record(nCount number,
sX varchar2(32000),
sY varchar2(32000));

type TextTable is table of TextData index by binary_integer;

In a loop I do the following and here stops my debug messages. Seems like the problem is located in these two lines of code.

potText(ponTextCount).sX := potText(ponTextCount).sX || to_char(nDiff, '9999.999999') || ' ';

potText(ponTextCount).sY := potText(ponTextCount).sY || to_char(cr.avg_value, '99999.99999') || ' ';

potText is the TextTable and ponTextCount is a number.

Can someone help me with this issue?

Best Regards
Roar

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2003

Added on Oct 30 2003

19 comments

527 views