SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting Char value into number field in PL/SQL

537114Nov 20 2006 — edited Nov 20 2006

All,

I am trying to insert a char value into a number field in a PL/SQL block and when ever I am trying to do so I am missing that record in the table. But I am not getting errors such as "can't insert character into number field". I am doing a conversion using to_char and then inserting into a variable defined as number. But I am not able to see that record in the table. Please suggest.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2006

Added on Nov 20 2006

19 comments

1,444 views