PL/SQL-Procedure longer than 32k
587269Jul 10 2007 — edited Jul 10 2007Hey there,
I am trying to upload a really long procedure into ApEx. But it's over 32k long, so it won't work. Basically it's the code of some SVG-graphic, that is mainly static, but since the color-codes will be generated out of data in a database, I have to upload it as PL/SQL code. I just prefixed (almost) all the lines with htp.p(' and put '); at the end.
Is there some workaround to have a procedure with more than 32k? Or could I split the file up somehow? Basically it's a map of some regions. Each is represented by a path, consisting of about 100 coordinates. Those paths should stay static. Is there some way to store them elsewhere and load them into the procedure at runtime?
BTW: I am using OracleXE.
The error message:
"ORA-20000: Line length 47284 exceeds maximum 32767 at line 73
Unable to parse the script."
Thank you in advance for your help. I am really new to this.
Yours,
Richard