How to build QMS0012F in Apex and integrate with Oracle Reports Server (part 1 of 5)

By WimPosted on Cat APEX Application Express
Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 For those of you who are in a long term migration of Forms applications to the Apex platform, this article might be of interest. Especially for developers who relied on Headstart Designer, which was a productivity booster for Oracle Designer, made by the Dutch Oracle Consultancy department.Part of the Headstart tool was the… Read More »

Submit Apex report parameters (part 4 of 5)

By WimPosted on Cat APEX Application Express, Oracle Report Server
Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 What should happen during submit? get the item values on the page and its data attributes and compose a JSON stringpass the JSON string to the databasein the database procedure, convert the JSON parameter and compose an URL for the Report Server. Validate values, for example when the Destination Type = FILE, the… Read More »

Open report page (part 5 of 5)

By WimPosted on Cat APEX Application Express, Oracle Report Server
Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 After posting the SOAP message to the database, we are waiting for the response. The response from the Report Server is wrapped as a <![CDATA[result]]> tag in the SOAP response. If the report has run successfully, this may be an example of the output: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Body> <ns1:runJobResponse SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:oracle-reports-rwclient-RWWebService"> <return… Read More »

Apex interacts with Oracle Reports Server (part 2 of 5)

By WimPosted on Cat APEX Application Express
Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 The user interaction of the generic Report submission form is very simple: the user chooses the report he wish to runhe fills in the (optional) parameter settings or selection criteriahe presses the [Submit] buttonhe waits for responsethe report output is opened and displayed in a new window. The actions are represented in following… Read More »

Rendering Apex generic Report Form (part 3 of 5)

By WimPosted on Cat APEX Application Express, Oracle Report Server
Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 The old stuff First step is to refresh your memory and have a glance at the (good) old Forms interface. I even have a screen print of a client/server environment (6i) which still works under a VM / Windows XP: In Oracle Forms the generic Headstart Report Launch Form looks like this: The… Read More »

Apex Free text search

By WimPosted on Cat APEX Application Express
I used to write my free text search SQL in Apex Standard Reports or as a Pre-Filter for Interactive Reports or -Grids like this, based on a single text field :P1_SEARCH Demo see: https://apex.oracle.com/pls/apex/f?p=80981:2 select emp.empno, emp.ename, emp.job, mgr.ename manager, to_char(emp.hiredate,'YYYYMMDD') hiredate, emp.sal salary, emp.comm commision, dep.dname departmentfrom empjoin dept dep on dep.deptno = emp.deptnoleft… Read More »

rubygems.rb:334:in `bin_path’: can’t find executable rails for rails-3.2.1 (Gem::Exception)

By WimPosted on Cat Mac Os, Ruby on Rails
After updating my MacOS I got this message: rails -v /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/rubygems.rb:334:in `bin_path': can't find executable rails for rails-3.2.1 (Gem::Exception) from /usr/bin/rails:19 $ sudo gem update rails Updating installed gems Updating coffee-rails Successfully installed coffee-rails-3.2.2 Successfully installed activesupport-3.2.8 Successfully installed activemodel-3.2.8 Successfully installed rack-cache-1.2 Successfully installed journey-1.0.4 Successfully installed sprockets-2.1.3 Successfully installed actionpack-3.2.8 Updating jquery-rails Successfully… Read More »

Installation of Ruby on Rails on Windows

By WimPosted on Cat Ruby on Rails1 Comment
The most convenient way to install the Rails stack is via downloading the Rails Installer. Download the Rails Installer kit from http://railsinstaller.org/ Packages included are: Ruby 1.8.7 Rails 3.0.6 Git 1.7.3.1 Sqlite 3.7.3 DevKit The file to be downloaded is railsinstaller-1.1.1.exe (47Mb). After downloading, just run the exe file and change the default installation path… Read More »