Home » Developer & Programmer » Forms » ora-06502
ora-06502 [message #79789] Fri, 12 July 2002 05:46 Go to next message
rose
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
FROM GEN_STUDENTS
WHERE reg_numb = :my_block.reg_numb
ND surname = :my_block.surname;

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

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.
Rose
Re: ora-06502 [message #79791 is a reply to message #79789] Fri, 12 July 2002 07:06 Go to previous messageGo to next message
N
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
Anand
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: Tue Oct 19 19:16:59 CDT 2021