Re: ORA-06502 character string buffer too small

In article <3B8502E9.8C12564D_at_sipri.se>, Gerd says...
>
>I upgraded to 8.1.7 but now my old procedures and web interface's from
>version 7 won't work anymore.
>Using PL/SQL Web Toolkit:.
>
>That's the error message:
>ORA-06502: PL/SQL: numeric or value error: character string buffer too
>small
>ORA-06512: at "DB.INPUT_FORM", line 316
>ORA-06512: at "DB.INPUT_CHCK", line 588
>
>Changed the value of the HTBUF_LEN variable. Nothing works. The package

that was rather drastic -- put it back to the proper length.

>is owned by SYS and it works with other procedures owned by the resp.

why do you have code owned by SYS? Oracle is the only one that should have code owned by SYS. Very dangerous.

>user. Don't get the message if the text string I move is smaller. But as
>I said it worked before with version 7.
>

did you change your characterset when you upgraded?

can you post the code from around line 316 of your routine (and perhaps why you felt changing HT_BUFLEN might help? what was the logic there?)

>It must be some settings which is wrong. At least that's my guess.
>
>Can anybody help. I searched the net for two days now to find a solution
>
>Thanks in advance
>
>Gerd
>__________________________________________________________
>Gerd Hagmeyer-Gaverus
>
>Stockholm International Peace Research Institute
>
>Signalistgatan 9
>S-169 70 Solna, Sweden
>Tel.: +46 - 8 - 655 97 68
>Fax.: +46 - 8 - 655 97 33
>e-mail: hagmeyer-gaverus_at_sipri.se
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp