conversion
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: conversion

  1. #1
    Join Date
    May 2002
    Posts
    232
    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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    msg_success CONSTANT NUMBER := 'OK';


    Why NUMBER ????





  3. #3
    Join Date
    Apr 2002
    Posts
    291
    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
  •  


Click Here to Expand Forum to Full Width