Re: OWA 1.0 Bug??

In article <popeye-1405960515580001_at_192.0.2.1>, popeye_at_arachnid.com (Robert Stucky) wrote:

> For some reason, all the text makes it except for the 5th block of 255
> characters.

Early version of the owa executable drop content as you have observed. If you are on Solaris, you need v1.0.2.0.1 of owa. (Execute owa -v to get its version.) You might check of the free sample download currently available (?) from www.oracle.com has the fixed version. 7.3 also ships with the fixed version. Otherwise Oracle support has a patch.

Here is a convenient procedure to illustrate the bug:

CREATE OR REPLACE PROCEDURE owabug( iterations INTEGER DEFAULT 11 ) AS

        counter INTEGER := 0;
        base    VARCHAR(100);
        string  VARCHAR(6000);
BEGIN
        -- the following string is 100 characters long when combined with
the formatted number
        base := ' one two three four five six seven eight nine ten eleven
twelve thirteen fourteen fifteen ';
        IF(iterations > 50) THEN
                htp.strong('TOO MANY ITERATIONS.');
        ELSE    
                WHILE counter < iterations LOOP
                        counter := counter + 1;
                        string := string||TO_CHAR(counter,'000000000')||base;
                END LOOP;
                htp.htmlOpen;
                htp.bodyOpen;
                htp.header(4,'Notice the missing text after 000000011.
Pass larger numbers in ''iterations'' paramter if you like.';
                htp.p(string);
                htp.bodyClose;
                htp.htmlClose;
        END IF;

GRANT EXECUTE ON owabug TO PUBLIC; Received on Wed May 15 1996 - 00:00:00 CEST