Oracle Forms 4.5 Database Connection
Budget: ₹1,500 – ₹12,500 INR
I have an existing Oracle Forms 4.5 application running in a legacy environment, but the code that previously opened a session against our Oracle 8 instance no longer works on the current machines. All objects—tables, views, and stored procedures—are already in place; I only need a clean, reliable way for the form to open a connection and read data from those objects.
What I need from you
• A PL/SQL or built-in Forms code snippet (PRE-FORM trigger, WHEN-NEW-FORM-INSTANCE block, or another appropriate hook) that establishes the session with Oracle 8.
• A brief example SELECT that proves the connection by returning a row to the form.
• Short notes explaining any environment variables, TNSNAMES.ORA entries, or FORMS45_PATH settings required so I can replicate the setup on another workstation.
Acceptance criteria
1. The form compiles without warnings in Oracle Forms 4.5.
2. On execution it logs in automatically, displays data from a sample table, and raises no ORA- errors.
3. Your notes let me reproduce the solution on a second PC within 10 minutes.
If you can keep everything native to Forms 4.5 and standard SQL*Net (no third-party drivers), implementation will fit perfectly into our current toolchain.
What I need from you
• A PL/SQL or built-in Forms code snippet (PRE-FORM trigger, WHEN-NEW-FORM-INSTANCE block, or another appropriate hook) that establishes the session with Oracle 8.
• A brief example SELECT that proves the connection by returning a row to the form.
• Short notes explaining any environment variables, TNSNAMES.ORA entries, or FORMS45_PATH settings required so I can replicate the setup on another workstation.
Acceptance criteria
1. The form compiles without warnings in Oracle Forms 4.5.
2. On execution it logs in automatically, displays data from a sample table, and raises no ORA- errors.
3. Your notes let me reproduce the solution on a second PC within 10 minutes.
If you can keep everything native to Forms 4.5 and standard SQL*Net (no third-party drivers), implementation will fit perfectly into our current toolchain.