Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle Form Builder - Database tables do not show when creating a new data block.
When creating a new data block in Oracle Form Builder, the tables that I have created do not show after connecting to database. Here are some screenshots :
However, I find all the tables when running the two command-lines in the command prompt :
sqlplus c##aimen/[email protected] select * from tab;
Here is another screenshot :
This is my tnsnames.ora file content :
Any idea how to fix that?
Comments
-
Does your DB username actually have "##" in it? If so, try adding quotes around the username. Note however that if you do this, the string will be submitted exactly as you enter it. Meaning for example it will be case sensitive. So be sure to enter it exactly as it appears in the DB.
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
Yes, my DB username does contain "##". Here are the command-lines that I ran in order to create it :
CREATE USER c##aimen IDENTIFIED BY mon_mot_de_passe CONTAINER=ALL; GRANT dba TO c##aimen CONTAINER=ALL;
I have actually tried to add quotes (whether simple or double ones) around it as it is shown in the screenshots below (for all the cases that I have tried).
However, I got the error message below for each one of them :
ORA-01017: invalid username/password; logon denied
-
Maybe SQLPlus and Forms Developer use different TNSNAMES.ORA files.
In the file you have shown ORCL points to the PDB ORCLPDB and perhaps in the other to the CDB$ROOT.
Actually ORCL is the default name of the CDB$ROOT in a Oracle 19 installation.
-
If you are connecting to a containerized DB, the Builder is only supported connecting to the PDB. Is that what you are doing?
Michael Ferrante
Senior Principal Product Manager
Oracle
Twitter: @OracleFormsPM
-
Indeed! I need to coonect to a PDB not a containerized DB.
I have finally fixed it! 😎
I just ran the command-line below:
ALTER SESSION SET CONTAINER = ORCLPDB;
Here are some screeshots that illustrate how I proceeded in details :
Many thanks for your tips! 🙂
-
Here is a tip: If you enter "chcp 1252" in your CMD window before starting SQLPlus your french characters are displayed correctly:
C:\>chcp 1252 Active Codepage: 1252. C:\>sqlplus hr/[email protected] SQL*Plus: Release 19.0.0.0.0 - Production on Jeu. Mars 17 08:34:23 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Heure de la dernière connexion réussie : Jeu. Mars 17 2022 08:34:00 +01:00 Connecté à : Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL>
-
I see...
Bunch of thanks for your tip 🙂