May 2000
Intermediate to advanced
594 pages
11h 32m
English
Q: | |
28-33. | The following function is a possible solution for this problem. Note the use of the SUBSTR function to perform ASCII-to-HEX conversion:
|
Q: | |
28-34. | The most likely cause of this problem is a buffer overflow. At the beginning of the time period, when there were just a few records, everything seemed to work fine. As more records were added, however, the system became noticeably slower. Finally, it exceeded the size of the HTML output buffer. Unfortunately, there is no PL/SQL workaround to this problem. A reasonable approach is to either break the file into sections or replace the PL/SQL procedure with a nonbuffered language such as Perl. |
Q: | |
28-35. | The original ... |