[Tutor] Oracle forms

[Alan Gauld]

On 22/03/18 15:22, David Holland via Tutor wrote:
> Is there anyway I can use Python to fill in an Oracle form

What kind of Oracle form? There are at least 2 that I'm
aware of.

1) The Oracle Forms thick client app framework which runs
   on a PC and connects to the database server. (I believe
this is now obsolescent and no longer supported by Oracle?)

2) Web Forms built using the Oracle web server framework

In either case it is usually better to access the database
directly from Python rather than trying to write data into
the GUI. The only case where the latter would be needed is
if the Forms client implemented some kind of data processing
prior to sending the data to the sever.

If that is the case you can try the usual screen or web
scraping options. But they are always messy and unreliable
so should be a last resort. Check that there isn't an
API you can use first.

Also the OS and Python version may make a difference so
let us know exactly what you need to do.

Finally, there are literally dozens of other Oracle
applications that all have forms interfaces (HR, CRM,
ERM, Workflow, Middleware, Financials, Java, etc etc).
So if it's not the database product you need to tell
us that too.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos