ORA-01858 a non-numeric character was found where a numeric was expected
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01858 a non-numeric character was found where a numeric was expected

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    ORA-01858 a non-numeric character was found where a numeric was expected

    This is a CF / SQL question. Please let me know if CF is taboo here.

    I have 11 sequences (one per category) represented in a form drop-down menu.

    I'm having a difficult time getting the selected sequence to work in the insert statement. The values that I've stored in the form are in this format:

    gpn_dft_seq.nextval
    gpn_ds_seq.nextval

    etc, etc till all 11 categories (and thus all 11 sequences) are represented.

    Please see below:








    insert into graphicpartnumbers
    (
    category_seq_no,
    category,
    currdate,
    fullname,
    description
    )
    values
    (
    to_number(#category#),
    '#striped_category#',
    'to_date(#currdate#)',
    '#fullname#',
    '#description#'
    )




    I keep getting a variety of errors depending on what modifications I try {with this line: to_number(#category#)}, including the one listed in the subject line.

    Any suggestions will be much appreciated.

    Thanks.
    Cam

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    What is "#category#" and why do you enclose it with #'s?

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