-
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
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
|