[Tutor] Oracle forms

[Mats Wichmann]

On 03/22/2018 11:35 AM, Peter Otten wrote:
> David Holland via Tutor wrote:
> 
>> Is there anyway I can use Python to fill in an Oracle form rather than
>> typing it in myself.I.e take values from a .csv file and put them into an
>> Oracle form.Any ideas (I have googled it) what libraries to use?
> 
> If I understand you correctly you want to enter data into a database, in 
> bulk. For that you typically bypass any GUI, and connect to the database 
> directly. With Python and Oracle that would look like
> 
> http://www.oracle.com/technetwork/articles/dsl/python-091105.html
> 
> As it is possible to do a lot of damage (provided you have the necessary 
> credentials) I suggest that you discuss this with your IT department before 
> you proceed.

>From the Python viewpoint, no clue.

Oracle Forms has its own API. Naturally, that requires a unique
scripting language to use ("but it's easy to learn!"). Maybe if they
were building it today they would use a known scripting language
instead, who knows. And the API package has, I believe, add-on costs.
It's Oracle, after all.