Print Thread
dbms_output of string with length exceeding 32512 causes PLD error ORA-06502: numeric or value error
#45723 01/19/13 10:31 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
I have a program unit which uses dbms_output.put_line to output a string with a length of e.g. 32520.

When run from at test script, this causes PLD to generate an ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Running PLD with the parameter debugsql, I can see that the method sys.dbms_output.get_lines(lines => Lines, numlines => :NumLines) is called to get the output. The resulting array (Lines) is saved in a string variable :Line0 := Lines(1) which seems to be defined too small (32512). Please check that the string variables :Line0 to :Line9 are defined as strings which can hold an Oracle Varchar2 of length 32767.

I have checked in the debugger that dbms_output.put_line can be called with strings up to 32767 in length without error, it is when PLD starts to retreive the data, the error appears.

This is also a problem in beta 6

Re: dbms_output of string with length exceeding 32512 causes PLD error ORA-06502: numeric or value error
Claus Pedersen #45726 01/21/13 09:37 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
We'll fix it.


Marco Kalter
Allround Automations
Re: dbms_output of string with length exceeding 32512 causes PLD error ORA-06502: numeric or value error
Marco Kalter #47558 07/30/13 07:57 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Bump: what is ETA for this fix?

Re: dbms_output of string with length exceeding 32512 causes PLD error ORA-06502: numeric or value error
Claus Pedersen #47565 07/30/13 08:40 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
It's a bit of a low-level issue, so his may need to wait until version 11.0.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.076s Queries: 14 (0.034s) Memory: 2.5097 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-05-04 10:15:24 UTC
Valid HTML 5 and Valid CSS