Re: ORA-06502 character string buffer too small

From: Gerd Hagmeyer-Gaverus <hagmeyer-gaverus_at_sipri.se>
Date: Mon, 27 Aug 2001 16:31:59 +0200
Message-ID: <3B8A59DE.41AE9771@sipri.se>

Dear Thomas

I knew it was drastic to change HTBUF_LEN and I changed it right back after I tested it. Also the htp, htf packages I installed according to instructions as user sys and with sqlload, that's why they are owned by SYS. I couldn't load them as user because the user didn't have enough privileges.

ORA-06512: at "DB.INPUT_FORM", line 316 -- here is the code:

315 v2 := key(user_name_v, user_number); 316 return('

317   <center>
318   <p><font size="7" face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><b>
319   <hr noshade size="6" width="100%">

320 User database

ORA-06512: at "DB.INPUT_CHCK", line 588 -- here is the code:

586 else
587 htp.print(header);
588 htp.print(db_input_form
589 (record_action,
590 Other_change_text,

The characterset has to my knowledge not been changed, but I have to check that.

Gerd

Thomas Kyte wrote:

> 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

--
__________________________________________________________
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

SIPRI homepage:
http://www.sipri.se

Received on Mon Aug 27 2001 - 09:31:59 CDT