Avatar of chembukar
chembukarFlag for United States of America

asked on 

PL/SQL: numeric or value error: character string buffer too small

Hey when i am running my application in the specific module i am getting this error as below:-
------------------------------------------------------------------------------------------------------------------------------
Error Type:
GNSBillboard_BS.BillboardBS.Save_Billboard_Instance() (0xFFFFE69A)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
/gns/scripts/Utility/Billboard.asp, line 108


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 188 bytes to /gns/scripts/Utility/Billboard.asp

POST Data:
txtBillboardTitle=test&txtBillboardLine1=+%3Ca+href%3D%27www.test.com%27+target%3D%27_top%27%3Etest%3C%2Fa%3E&checkbox1=on&txtBillboardLine2=&txtBillboardLine3=&txtBillboardStatus=A&mode=C

Time:
Wednesday, July 23, 2008, 6:01:09 PM
------------------------------------------------------------------------------------------------------------------------------
For your ref. enclosed the .doc which explains the error with another text file with table name and related procedure..
kindly anybody provide solns..
thx in adv..............
- KC-Ram..

billboard-error.doc
proc-tablename.txt
Oracle DatabaseWeb Applications

Avatar of undefined
Last Comment
chembukar
Avatar of yuching
yuching

it's because one of your variable length is smaller than the pass in value length. You can verify the length first before assign or insert into table.  
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of chembukar
chembukar
Flag of United States of America image

ASKER

gave me a idea to check the store procedure..
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo