| ora-06502 [message #79789] |
Fri, 12 July 2002 05:46  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
