APEX

Hi All,

I am facing problem with SQLERRM & SQLCODE.

I want to insert into emp table.

if any exception will occur then Error code and error message needs to insert into my error log table i.e "ERROR_LOG_INFO" as below.

In the above code i have inserted empno as NULL then it goes to exceptions block and inert into error_log_info table.

The error_log_info table result as below.

But i want to insert the error code and error message as

I want to insert proper error message and Error Code into error_log_info as show in above screen

Please help me out regarding this.

Thanks,

Hanu