Skip to Main Content

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!

Insert incoming boolean into a varchar(1) column

user5108636May 2 2018 — edited May 3 2018

Hi All,

      I am using Oracle 12c. In the PLSQL block, I want to do an insert of an incoming boolean field by converting it to my corresponding varchar(1) column. Values should be Y/N for true/false.

error log table contains a field is_internal_error(varchar(1))

insert into error_log (message,is_internal_error) values (p_error.message,p_error.is_internal_error);

I am getting compile error expression of wrong type PLSQL-00382

Thanks

This post has been answered by mathguy on May 2 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2018
Added on May 2 2018
9 comments
2,931 views