Hello,
ISSUE
I'm trying to write many lines in the HTML of my plugin. In order to do so I stocked all my HTML lines in a very long CLOB called "JScript". I use htp.prn to write JScript in my HTML. Since htp.prn can't all JScript lines I sample JScript into substrings that I give to htp.prn. Unfortunatly the code I wrote give me back errors.
CODE
jsonString CLOB;
x int;
i int :=1;
...
x:=ROUND(JScript.length/32767);
FOR i IN 0..x LOOP
htp.prn(DBMS_LOB.SUBSTR(JScript, 32767, i*32767+1));
END LOOP;
IF JScript.length>x*32767 THEN
htp.prn(DBMS_LOB.SUBSTR(JScript, JScript.length-x*32767, x*32767+1));
END IF;
ERROR
ORA-06550: line 613, column 20: PLS-00487: Invalid reference to variable 'JSCRIPT' ORA-06550: line 613, column 3: PL/SQL: Statement ignored ORA-06550: line 617, column 14: PLS-00487: Invalid reference to variable 'JSCRIPT' ORA-06550: line 617, column 3: PL/SQL: Statement ignored
Any help is appreciated.
Thank you for reading.