Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: set_block_property (ORA-06502 error)

    guys,

    following is my code-----
    p_taxicode := 2;
    go_block('C_TAXIMST');
    clear_block(no_validate) ;
    -- set_block_property('C_TAXIMST',DEFAULT_WHERE,'wher e taxicode '|| ''''||p_taxicode||'''') ;
    set_block_property('C_TAXIMST',DEFAULT_WHERE,' taxicode= 1') ;
    execute_query('C_TAXIMST');


    i got error ORA-06502 although in entry mode form is running ok.
    shit-f1 also not helped in this regards

    regards
    vinod

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by Oracle
    ORA-06502 PL/SQL: numeric or value error string

    Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).

    Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.
    I *suspect* that 'taxicode' column is of a character datatype, so - in order to make it work - you should enclose its value into single quotes.

    WRONG: taxicode = 2
    CORRECT: taxicode = '2'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •