Tuesday, April 16, 2019

APEX 5 - interactive report scale resize image

APEX 5 - interactive report re-size image


1. Add image column to interactive report
2. Add blob attributes (image column at your report should be primary key for table with blob content)
3. Add Static ID for your image column (f.e. IDP)
4. Add HTML Header in Page Properties
f.e.

<style type="text/css">
td[headers="IDP"] > img
width: 150px;
}
</style>







Problem with database open ORA-19804, ORA-19809, ORA-03113

1. Try to login to database with SYS AS SYSDBA user. If the instance is idle, run the startup command. 2. If ORA-03113 occured, check the la...