-
Hi Folks
On the following code
PROCEDURE CongratPg(
p_pid IN NUMBER DEFAULT 0,
p_userName IN VARCHAR2 DEFAULT NULL,
p_passwd1 IN VARCHAR2 DEFAULT NULL,
p_passwd2 IN VARCHAR2 DEFAULT NULL,
p_submit IN VARCHAR2 DEFAULT '1')
IS
--
BEGIN
IF (p_userName = p_passwd1) THEN
v_errorMsg := 'Your user name and password cannot be the same.';
v_button := 'Submit';
ELSIF ( NVL(p_passwd1,NULL) <> NVL(p_passwd2,NULL)) THEN
v_errorMsg := 'Please re-enter your password';
v_button := 'Submit';
END IF;
END CongratPg;
The problem I'm having here is that I'm not able to generate the error messages. Instead i'm getting
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Could some one tell me how to do the comparison.
Thanx,
Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|