araczkowski/apexhtml2pdf

apexHtml2Pdf

a new solution to for the reporting in Oracle APEX

HOWTO

1. this plugin requires the JSON support in DB, so first install the pljson library

Step by step:

clone pljson repo git clone https://github.com/araczkowski/pljson

in the terminal go to the repo directory cd pljson

connect to Oracle DB as user/schema that you are using in your apex app sqlplus user/pass@sid

run the installation scirpt @install.sql

2. install the plugin

replace the package body for JSON_PRINTER, using this version: https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/JSON_PRINTER.sql

install the plugin https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/APEX_PLUGIN_JSREPORT_SPEC.sql https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/APEX_PLUGIN_JSREPORT_BODY.sql

configure ACL: https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/acl.sql

add grants: https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/grants.sql

install demo app: https://github.com/araczkowski/apexHtml2Pdf/blob/master/backend_snippets/f100.sql

apexhtml2pdf's Issues

Compilation Error

Compilation failed,line 150 (09:24:31)
PLS-00103: Encountered the symbol ")" when expecting one of the following: . ( , * @ % & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || multiset member submultiset format Compilation failed,line 175 (09:24:31)
PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: end not pragma final instantiable persistable order overriding static member constructor map The symbol "static" was substituted for "PROCEDURE" to continue. Compilation failed,line 219 (09:24:31)
PLS-00103: Encountered the symbol "FUNCTION" when expecting one of the following: end not pragma final instantiable persistable order overriding static member constructor map Compilation failed,line 220 (09:24:31)
PLS-00103: Encountered the symbol "APEX_PLUGIN" when expecting one of the following: ( The symbol "(" was substituted for "APEX_PLUGIN" to continue. Compilation failed,line 221 (09:24:31)
PLS-00103: Encountered the symbol "APEX_PLUGIN" when expecting one of the following: ( The symbol "(" was substituted for "APEX_PLUGIN" to continue. Compilation failed,line 222 (09:24:31)
PLS-00103: Encountered the symbol "RETURN" when expecting one of the following: ) , and or The symbol ", was inserted before "RETURN" to continue. Compilation failed,line 224 (09:24:31)
PLS-00103: Encountered the symbol "L_RESULT" when expecting one of the following: not null of nan infinite dangling a empty json.

l_content := json_value(l_content_clob);

spec JSON_PRINTER pkg

Hi Can you please share the spec for the JSON_PRINTER pkg, your way of approach is very good, but while i am creating pakage getting lot of errors , will you help me?

Request

pakage body not created.

Hey,

APEX_PLUGIN_JSREPORT_BODY pakage body i am facing below mentioned error.

Error at line 91: PLS-00201: identifier 'JSON' must be declared

please help me in this regards.

Help Request

Hello Andrzej,

I saw your video https://www.youtube.com/watch?v=BIJZG6dx1z4. This is a wonderful tutorial. Could you please let me know how to program the "Print" button from this video.

Thanks,
Sriya