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

Thread: conversion

  1. 07-03-2002, 11:12 PM #1
    kavithared
    kavithared is offline Member
    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
    Reply With Quote Reply With Quote
  2. 07-04-2002, 12:28 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    msg_success CONSTANT NUMBER := 'OK';


    Why NUMBER ????




    Reply With Quote Reply With Quote
  3. 07-04-2002, 12:35 AM #3
    pnrdba
    pnrdba is offline Senior Member
    Join Date
    Apr 2002
    Posts
    291
    You are giving a value in ' ' and declaring the datatype as number?? huh!!! declare it as varchar2
    PNRDBA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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