What's the previous post?
I posted something months ago, but I never received a reply.
Define a record with initialization values:
TYPE type_delinq_report_det_1 IS RECORD
space1 CHAR := ' ',
space2 CHAR(3) := ' ',
space3 CHAR := ' ',
space4 CHAR := ' ',
space5 CHAR := ' ',
space6 CHAR(9) := rpad(' ',9,' '),
space7 CHAR(2) := ' ',
space8 CHAR(2) := ' ',
space9 CHAR := ' ',
Define an array of that record:
TYPE type_table_delinq_report_det_1 IS TABLE OF type_delinq_report_det_1 INDEX BY BINARY_INTEGER;
Create an instance of the array and reference it in the package.
Debug will not run in this scenario. It simply does nothing - no errors, no response, nothing. We determined this by removing pieces of code until we found the culprit.
To clarify, you have to actually assign a value to one of the fields in the record that was initialized. For example,
delinq(1).net := 10;
If you never got a reply, odds are it didn't go anywhere.
What version of Oracle Database, what version of SQL Developer are you doing this with?
Formal bug reports should go to My Oracle Support. I'll try to take a look at this though.
We are on 11g. We're currently using Developer 4.0, but it also happened with 3.2. It did not occur when we were on 10g.
Yes, that's the version we're on.