Databases
StackOverflow2013
Postsdbo
POAPEX: Export *only* app components programmatically - how?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAPEX: Export *only* app components programmatically - how?
    primarykey
    data
    text
    <p>At a higher level I have a task to maintain my APEX application in a Subversion repository, thus, I need to implement a consistent (and easily importable) set of files.</p> <p>My first option was to user Oracle's Java-based utilities (APEXExport &amp; Apexsplitter). </p> <p>Export worked just fine, but I didn't want to keep large app-wise files, and splitter part appeared to be error-prone (I wasn't able to re-import splitted application due to some constraint violations, which I didn't investigate).</p> <p>Another option, I tried to use WWV_FLOW_UTILITY's API. This one is fine for both app-wise and page-wise export, which I currently have, but I would also like to keep application components as separate files.</p> <p>I don't actually want to export anything using APEX web interface; I've done some additional research upon system packages and found WWV_FLOW_GEN_API2, which seems to be able to export components separately, but it seems unintuitive (at least in comparison with WWV_FLOW_UTILITY) and undocumented.</p> <p>So... Any chance for an easy way to export components into separate files, or my only way here is to try to play with gen_api2 or (lol, actually, no) try to emulate web interface and reproduce these HTTP POST requests that generate an .sql for any given set of components?</p> <p>Thanks.</p> <p><strong>update</strong>: Here's the error I get when I try to import splitted app:</p> <pre><code>......Button Template 572358005406745047 begin * ERROR at line 1: ORA-00001: unique constraint (APEX_040100.WWV_FLOW_BUTTON_TEMP_PK) violated ORA-06512: at "APEX_040100.WWV_FLOW_API", line 6711 ORA-06512: at line 3 </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USbe here now
    1. USbe here now
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAPEX: Export *only* app components programmatically - how?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI believe that if you really need some technical insight into this, you're better off asking this question on the OTN forums, where these topics have come around now and again and many more specialists reside. I'd like if SO had a more active and experienced apex audience, but there just isn't. Either way, i disagree with your approach: using the wwv_flow apis such as you find in page exports is bound to leave you in trouble sooner than later.
      singulars
      1. POAPEX: Export *only* app components programmatically - how?
      1. USTom
    2. COI'm an APEX newb and I'm totally open to suggestions! I agree with you that trying to reinvent the wheel is definitely not the best thing to come up with, but, well, the funny thing is, I might *likely* get in trouble if I stick to flow apis, but I am *already* in trouble with apexexp+splitter. :) Yeah, I will probably re-import my app if I kill dupes in install script, but would that thing become trustworthy after that? I don't think so. So, looks like all I have left is native web export.
      singulars
      1. POAPEX: Export *only* app components programmatically - how?
      1. USbe here now
    3. COThing is that flow apis are undocumented features: they might change without you having any notice during an upgrade, setting yourself up for potential trouble. There is no real "official" way of breaking up a page in pieces, so that is the most finegrained thing you're getting at this time (not that i'd not like it otherwise). But if i were you, i'd gather more opinions and experiences on the oracle apex forums - just in case. Just be careful with what you choose now so that you won't find yourself in a heap of trouble further on.
      singulars
      1. POAPEX: Export *only* app components programmatically - how?
      1. USTom
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload