Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Monday, 18 April 2016

How to connect database from oracle form builder

Open form builder and use shortcut Ctrl+J, it will ask database user name, password and service name as below

Note: Before give credential you should save TNS entries following path NETWORK >ADMIN

Share this article :


  1. Hi There,

    Three cheers to you ! Hooray!!! I feel like I hit the jackpot on
    Oracle Applications
    I have a table with the details use rid, Latitude and Longitude. I will provide the current location (latitude and longitude) of the user and I need to get the list of users who belongs 1 km.

    Input: Latitude, Longitude, Distance
    Output: List of users who belongs with in the distance.

    Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.


  2. Hi There,

    Fully agree on How to connect database from oracle form builder . We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.

    can you please help me out on this.

    The error what I am getting is (ORA-00904) highlighted at the end with RED color.
    Below is the process what followed.
    I think the issue with build query with QUOTES(').

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).

    Best Regards,

  3. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  4. Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up. natural pool builder spicewood tx

  5. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  6. Thanks for sharing the post.. parents are worlds best person in each lives of individual..they need or must succeed to sustain needs of the family. construction crm