Search code examples
plsqloracle-apexoracle-apex-5

Apex Office Print Plugin : Error when downloading pdf report

I imported AOP plugin to my application for making a report with a customized template made in word and then linked to a button using a process but when the button is clicked, following error appears:-

     ORA-06550: line 4, column 46: PLS-00201: identifier 
    'AOP_API3_PKG.F_PROCESS_AOP' must be declared ORA-06550: line 4, column 
     1: PL/SQL: Statement ignored.

From AOP documentation, i learned that for Apex 5.1,I must import dynamic_action_plugin_be_apexrnd_aop_da_51 instead of process_type_plugin. Doing so leads to another error in the Sql query i.e wrong number of columns selected in the Sql. However i was able to run the page but with error as follows:-

    'AOP_API3_PKG.F_RENDER_AOP' must be declared.

error

Has LibreOffice necessarily be imported to the application to be able to print in PDF form? Please can anyone help. Waiting for a prompt reply Thanks

Solution

  • It looks like you didn't run the script aop_db_pkg.sql which you find in the db folder in the parsing scheme your application is linked to. See also: https://www.apexofficeprint.com/docs/#19-quick-install-guide

    Can you verify if in SQL Workshop > Object Browser you see the package aop_api3_pkg?