-
Hi,in my procedure output parameter datatype varchar2
by using this one i need to raise exception.
msg_success CONSTANT NUMBER := 'OK';
i get a error
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "WEBDBDEV.IVR_CHANGE_TPIN", line 19
ORA-06512: at line 13
any one can help me conversion
kavitha
-
msg_success CONSTANT NUMBER := 'OK';
Why NUMBER ????
-
You are giving a value in ' ' and declaring the datatype as number?? huh!!! declare it as varchar2
PNRDBA
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
|