Assumption: In my office I have a licensed formspider IDE and am using it for development against my own office DB.

How do I deploy a new ersion of that app to five different runtime-only customers? I know how to update my application packages but what about the formspider app? Is there a SQL*Plus "replace application" type script?

asked 24 Nov '14, 02:52

dipr's gravatar image

dipr
1561325
accept rate: 0%

Hi Paul,

Yes, there is. I am outside the office right now but I'll update this thread with the script later.

(24 Nov '14, 03:51) Yalim Gerger ♦♦

Hi Paul,

Please note that the API used in the script below to import an application to a Formspider installation will change in the next version Formspider 1.9. I'll update this post after Forspider 1.9 is released.

Here is the script:

declare
  v_oracleDirectory_tx varchar2(255) := 'DEPO_DIR'; 
  v_applicationName_tx varchar2(255) := '[The Name of Your Application]';
  v_xmlFileName_tx varchar2(255) := '[The Name of the Export File]';
  v_cl clob;

  v_file bfile;
  v_destoffset number:=1;
  v_srcoffset number:=1;
  v_warning number:=0;
  v_context number:=0;

  v_objectRecord_tt bdf_etl.tt_importObjects;

begin

  bdf_application_api.applicationdelete(in_application_oid=>bdf_application_qry.getid(v_applicationName_tx), in_cascade_yn=>'Y');

  dbms_lob.createtemporary(v_cl,true);
  v_file  := BFILENAME(v_oracleDirectory_tx, v_xmlFileName_tx);

  dbms_lob.open(v_file, dbms_lob.lob_readonly);

  dbms_lob.loadclobfromfile(v_cl, v_file, DBMS_LOB.LOBMAXSIZE , v_destoffset, v_srcoffset, nls_charset_id('AL32UTF8'), v_context, v_warning);

  dbms_lob.close(v_file);

  bdf_etl.load(in_bdf_xml=>xmltype(v_cl),
               in_importOption_cd =>'AsNewApplication', 
               in_projectOption_cd=>bdf_constant_etl.etlcreateOrReplace,
               in_applicationOption_cd=>bdf_constant_etl.etlcreateOrReplace,
               in_importObjects_tt=>v_objectRecord_tt);

  commit;
end;
link

answered 27 Nov '14, 07:33

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×20
×13
×3

Asked: 24 Nov '14, 02:52

Seen: 970 times

Last updated: 27 Nov '14, 07:33


© Copyright Gerger 2017