OraOpenSource / apex-plugin-clob-load

Oracle Application Express (APEX) Plugin for form items with long text content (over 32k)
Other
21 stars 3 forks source link

No Directions / Can't install stample UnitTestApp #9

Open BostonBud opened 6 years ago

BostonBud commented 6 years ago

I'm using an 11.g database and Apex 5.01. I'm testing applications from Apex 4.2 and have run in to a problem with a plugin. I used the Enkitec Plugin in 4.2 so that I could write from a rich-text field in Apex to a CLOB field in the database and it worked fine. I found this plugin for Apex 5.x but I can't get it to work. There are no directions.
I can import the Plugin in Apex 5.1, but I'm not sure how to implement it in an application. There's code for a sample application, but when I go to run the SQL for the sample application in SqlDeveloper with SYSDBA privileges, the install doesn't complete. If I comment out the first line in the sample app (set define off verify off feedback off) and run the script in SQL Developer I get the following Script Output:

PL/SQL procedure successfully completed.

--application/set_environment
APPLICATION 123 - APEX CLOB Load Plugin Unit Testing Application
--application/delete_application
Rollback

Error starting at line : 72 in command -
begin
wwv_flow_api.remove_flow(wwv_flow.g_flow_id);
end;
Error report -
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_050100.WWV_FLOW_API", line 1453
ORA-06512: at "APEX_050100.WWV_FLOW_API", line 1488
ORA-06512: at "APEX_050100.WWV_FLOW_API", line 2302
ORA-06512: at line 2

How can I install the sample application and where would I find directions. Thanks very much for looking at this.

sthilaire commented 6 years ago

Have you tried using the import process through the APEX UI? Doe s it also give you an error?