oracleforms

Accessing URL parameters in Oracle Forms / OC4J

How do I access parameters passed into an Oracle Form via a URL. Eg given the url: http://example.com/forms90/f90servlet?config=cust&form='a_form'&p1=something&p2=else This will launch the 'a_form' form, using the 'cust' configuration, but I can't work how (or even if it's possible) to access p1 (with value of 'somethi...

How can I display a calendar control (date picker) in Oracle forms 9/10?

How can I display a calendar control (date picker) in Oracle forms 9/10? ...

Best solution for migration from Oracle Forms 6i to the web?

I work in an Oracle shop. There's a toolset that consists of roughly 1000 Oracle Forms (using the Forms builder from 6i, early 90's software) with Oracle 10g on the back end. It's serving roughly 500 unique people a month, with 200 concurrent connections at any given time during the work day. Obviously this is something that needs to ...

How to read the PL/SQL code in an Oracle Forms .FMT file ?

Oracle Forms10g provides a tool to convert the Oracle Forms modules, from the binary format (.FMB) that Oracle Forms Builder works with, to text format (.FMT). For example, if you create a module called mymodule.fmb with Oracle Forms Builder, and then invoke frmcmp module=mymodule.fmb script=yes batch=yes logon=no from the command li...

Converting Oracle Forms 10 to Java

There are a number of commercial products available: Exodus Evo Also Oracle Application Express (APEX) is releasing a Forms Converter in Oracle Application Express 3.2 (which is now in beta). Has anyone used any of these tools? How much of the process do they automate? What’s the quality of the converted code? Are they worth the co...

Query/Where dialog in Oracle Forms 10g

In Oracle Forms 6i, you could enter query mode in your form, and type & or :A in a field, and when you executed the query, a Query/Where dialog box would open, allowing you to enter more complex query or sorting criteria than just entering data in the fields allows. This doesn't seem to work in Forms 10g: I get a "FRM-40367: Invalid Cri...

Comparing Oracle Forms modules

We've inherited a large Oracle project that was originally Oracle 9 and is now Oracle 11. We don't have much confidence in the Forms change register. Are there any tools we could use to compare the two Forms projects? (By virtue of the fact that two different versions of Forms are involved, there will be differences even though the un...

Oracle Forms application direction

We have a big Oracle Forms 10 application and have been thinking about future direction. The choices seem to be: Continue development with Forms (Oracle has stated it will continue support). Do future development with Oracle Application Development Framework (ADF) and Oracle JDeveloper. This can co-exist with Forms. Migrate the whole a...

Oracle Form Builder: Switching between tabs in a form

Hi guys, i am building a form in oracle forms builder i have a tabbed canvas i need to know how to swap to the next tab when a button is pressed so what do i program into the next-tab button?? ...

Oracle Forms/Applications in Internet Explorer 8 using JInitator

Has anyone been able to get Oracle Forms running JInitator to loan in Internet Explorer 8 yet? I have tried removing all add-ons, various version of Java, add the domain to the trusted sites using wildcards, and using compatibility mode to no avail. I am looking to get our Oracle guys to kick there Internet Explorer 6 habit. This is r...

Oracle Forms 10 / java

Is it possible for a java application, called by Oracle Forms, to participate in the same database session like Forms? ...

How to get the WTSClientAddress from the java.lang.Object getClientInfo()

In one of our current web application we are using the getClientInfo() from a java.lang.Object reference in our Oracle Forms application which works great for egtting the client IP address of a system. However we recently started to use Windows Terminal Servers in our organization, and we are now having the problem with this code return...

How do you go about implementing WEbUtil with Oracle Forms 10g

we are in the process of doing a Forms 10g upgrade from 6i and we cannot get the WebUtil utility to work, can anybody with first hand experience explain how you go about doing it ...

Accessing a Windows file folder from Oracle Forms 10g

I would like to have a block in an Oracle 10g form that would show all of the PDF files in a particular folder on the user's C drive. The user should at least be able to double-click on the file to open it, and ideally be able to delete and rename the files, too. The list of files should show the filename (obviously) as well as the siz...

Geolocation assisted ATM monitoring

hi there, we would like to write a web based application to monitor the ATM machines in the bank to have the following functionality: Display location of each terminal Display general status of the terminal in color coding or simple icon (ATM up/Down/needs attention, low cash, etc.) Have a facility to drill down on the status of the...

Consuming .NET web service in Oracle Forms

I have a web service that i need to consume in Oracle Forms. The web service is SOAP based service and was generated using Microsoft Biztalk Server. The service accepts a complex xml message as its request and returns a similar xml message as response. I want to consume this service from within my Oracle Forms Application (Forms version ...

Saving PDF file to Shipment in Oracle

I have a web site that allows the user to generate a PDF Export Document based on shipment data in Oracle. One requirement is to save the PDF file to the shipment in Oracle. Does anyone fimiliar with Oracle Order Management know if there is a BLOB field associated with the shipment that I could store this in or an API I can call from m...

Vista focus issue when invoking Microsoft Word spell check from Oracle Forms

Friends, In testing our Oracle Forms application on Vista I have found a interesting "challenge". The application can invoke the Microsoft Word spell checker to perform a spell check on a field. When invoked, the user is shown the standard Microsoft Word spell checker dialog window. Word itself is invisble to the user. The Spell Che...

install has detected an invalid Active EMD Home configured as </some/path/>

"Possible cause for this error may be a previous installation of Oracle Application Server that was not completely installed or deinstalled. Please perform a deinstall on that home." I believe I have deinstalled it, together with the database. And when I use runInstaller and choose deinstall, it doesn't show up. Asking google yields 6 ...

Undo a POST in Oracle

Can anyone think of a way to reverse a POST that has been issued in Oracle Forms? Note; this is a POST, not COMMIT. Its quite complex but basically I need to POST so I can query against some records that will normally be created but at a later point I may need to change some values. This requires me to undo the previous POST. I've tri...