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

Pages

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 :

2 comments:

  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.

    Thanks,
    Morris

    ReplyDelete
  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,
    Preethi.

    ReplyDelete