Home » Developer & Programmer » Forms » ora-06502
ora-06502 [message #79789] Fri, 12 July 2002 05:46 Go to next message
Messages: 7
Registered: October 2001
Junior Member
Hello Everyone,

I am attempting to check if a user account exists in my table already when a user submits his/her registration number and surname. Here's my code:

SELECT COUNT(reg_numb)
INTO v_count
WHERE reg_numb = :my_block.reg_numb
ND surname = :my_block.surname;

IF v_count > 0 THEN
v_alert := ('already_registered_alert');

On execution, I recieve this error - ORA-06502:
PL/SQL: numeric or value error: character string buffer too small

I have confirmed that my table column sizes are the same as the block's column sizes and v_count has been declared as a number. It should return one row. This code is run from a WBP trigger.

Thanks for any suggestions.
Re: ora-06502 [message #79791 is a reply to message #79789] Fri, 12 July 2002 07:06 Go to previous messageGo to next message
Messages: 26
Registered: April 2002
Junior Member
what about v_count (check size of this) also.
Re: ora-06502 [message #80589 is a reply to message #79789] Thu, 17 October 2002 11:34 Go to previous message
Messages: 161
Registered: August 1999
Senior Member
I think you should check with that alert assignment hope the mistake is in that part
Previous Topic: Oracle Form Question
Next Topic: Re: Oracle Forms 6i 'Exit the application'.
Goto Forum:

Current Time: Thu Dec 08 03:18:24 CST 2022