Filter Oracle Connection

Filter Oracle Connection


If the error above appears when connecting to the database and then creating a new application, it is necessary to make some changes regarding the database:

Obs: For such changes it is necessary to know the owner who has view of the tables, such configuration must be changed/configured by the database manager.

      1. Editing the database connection



            When opening the connections choose the connection whose error is displayed




Changing table owner

            Open the Filter tab to perform the next steps



      2. In the Filter tab edit the owner and then change the flag Show to "Yes".



Changing the Database Schema

       1. Still in the connection tab, you can pass a Schema of your database.


             This way, only the tables that belong to the informed schema will be listed.

    • Related Articles

    • Filtering Connection Database - Oracle

      On various occasions, we encounter slowness when connecting to the database or while editing and executing applications. It is possible to resolve these issues by optimizing data loading through filter configuration. To do so, follow these steps: ...

    • Filter on Form Aplication

      This application filters data that will be displayed on editing forms. This type of application necessarily works linked to a form.  The table used to create this application must be the same as the one used to create the form. In this article we ...

    • Oracle Connection - Scriptcase 8.1 - Linux

      To enable the connection to Oracle on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 ...

    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...

    • Connection to Sybase PDO DBLIB

      In Scriptcase, we have the following drivers available for connecting to Sybase: Sybase PDO DBLIB, Sybase PDO ODBC and Sybase. If you are using your own, pre-configured environment, the Sybase extension must be enabled manually in PHP. NOTE: If you ...