Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing supporting objects with sqlplus

Nico MartensJul 2 2012 — edited Jul 3 2012
Hey,

For our development cycle we use jenkins with liquibase to automatically build our plsql backend code.

We want to do the same thing for our APEX applications.

After some searching I found that I needed to set the workspace, application id and schema with the apex_application_install api. I also generated an offset.

After doing this setup (without liquibase cause all of this is not supported by liquibase) the installation of the application is without any errors.

Now I exported my supporting objects as a single file and I'm also executing this with jenking (in the end I just open an sqlplus session and execute these files).

But when I do something like this:
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := 'some code for images';

declare
    l_name   varchar2(255);
begin
    l_name := 'uncheck.png';
 
  wwv_flow_api.create_or_remove_file(
     p_name=> l_name,
     p_varchar2_table=> wwv_flow_api.g_varchar2_table,
     p_mimetype=> 'image/png',
     p_location=> 'APPLICATION',
     p_nlang=> '0',
     p_mode=> 'CREATE_OR_REPLACE',
     p_type=> 'IMAGE');
 
end;
/
My image would not be added to the application.

When I do the exact same thing but change the p_location parameter to WORKSPACE instead of APPLICATION this code would work.

I wonder if I need to set some other stuff in the wwv_flow_api for the p_location=>'APPLICATION' to work.

It's not that it would stop our development but it's just inconvenient that we can not link images to applications anymore if we want to be able to use automatic building tools.

Any help is appreciated.

Br,

Nico

Comments

EJP

Please clarify. You state "It doesn't throw any error exception in the server class console but server class stops before completion", and you also post an exception. Which is it?

EJP

No clarification forthcoming. Locking as meaningless.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 31 2012
Added on Jul 2 2012
2 comments
630 views