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