Stack Overflow
Stack Overflow

Questions tagged [oracle18c]

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g, Oracle 12c, Oracle 18c, etc.

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g, Oracle 12c, Oracle 18c, etc.

Questions tagged oracle18c are assumed to be specific to this version or features introduced in this version. A list of features added in Oracle 18c can be found on in the Oracle Database Release 18c New Features guide.

Questions should probably be additionally tagged for the widest readership.

Questions about SQL in general should probably be tagged .

Questions about PL/SQL in particular should probably be tagged as well as .

Questions concerning installation or operation may be asked at Server Fault.

Oracle's documentation is quite extensive, and answers to many questions can be found there. It can be found here.

325 questions
14
votes
1 answer

Hibernate dialect for Oracle Database 18c?

Is there a Hibernate dialect for Oracle Database 18c? Or should I use the org.hibernate.dialect.Oracle12cDialect that ships with Hibernate? When using Hibernate 5.3 and Oracle 18c RAC is there anything special the application has to take care of?
Chris
  • 15,429
  • 19
  • 72
  • 74
7
votes
3 answers

Network access denied at "SYS.DBMS_DEBUG_JDWP"

When trying to save a trigger I get this error Connecting to the database XE. Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.56.1', '59537' ) ORA-24247: network access denied by access control list (ACL) ORA-06512: at…
Paul
  • 776
  • 1
  • 5
  • 18
6
votes
3 answers

Statement.setQueryTimeout doesn't work on Oracle 18c jdbc driver

We have a J2EE application on a payara 5.2020 server that executes a long running query (PL/SQL that executes for a couple of hours). To avoid a timeout exception, we use this sentence at StatementLevel: statement.setQueryTimeout(0); This works…
kothvandir
  • 2,111
  • 2
  • 19
  • 34
6
votes
2 answers

ORA-65096: invalid common user or role name

Hi I've tried to create a new user in Oracle 18c XE, but I get ORA-65096: invalid common user or role name error when writing create user student identified by "student"; I've tried to change the container to PDB by SQL> alter session set…
Cristina Moroti
  • 77
  • 1
  • 1
  • 8
5
votes
1 answer

SQL Developer doesn't display XML

Oracle's SQL Developer doesn't display the content of XML columns when the datatype XMLType is used. The first lines are displayed ok (if Preferences > Database > Advanced > Display XML Value in Grid is ticked), but once you doubleclick on the…
wolφi
  • 8,091
  • 2
  • 35
  • 64
5
votes
4 answers

Oracle 18c - Alternative to REGEXP_REPLACE

After migrating to Oracle 18c Enterprise Edition, a function based index fails to create. Here is my index DDL: CREATE INDEX my_index ON my_table (UPPER( REGEXP_REPLACE ("DEPT_NUM",'[^[:alnum:]]',NULL,1,0))) TABLESPACE my_tbspace PCTFREE …
user3224907
  • 758
  • 2
  • 15
  • 40
5
votes
9 answers

Getting "Unable to check for available memory." on Oracle DB 18c

I am trying to create a database in order to complete my self learning, but unfortunately I got unexpected error "Unable to check for available memory.", I am doing it using Database Configuration Assistant (DBCA). My Oracle Database Version
Yusuf Ibrahim
  • 1,591
  • 5
  • 21
  • 46
4
votes
1 answer

Why does CAST truncate text instead of throwing an error?

Casting text to a length that is shorter than the value results in truncated text. select cast('ROAD-1234' as varchar2(8)) as id from dual ID -------- ROAD-123 --^ Notice that the number 4 has been removed I would have…
User1974
  • 276
  • 1
  • 17
  • 63
4
votes
0 answers

Can't set named (or ordinal) parameters in SQL if inside a string

Project settings are: Java 8, Hibernate 5.3.1, Oracle 18c Getting the following error when executing queries with named or ordinal parameters. Happens only if the parameters are inside a function select * from TABLE_PRIVILEGE a where ( ( …
Anca T.
  • 41
  • 4
3
votes
1 answer

Why does deterministic function return unexpected numbers in CONNECT BY LEVEL query?

Test #1: I have a user-defined function and a CONNECT BY LEVEL query: with function custom_function(p_id in number) return number is begin return p_id; end; select custom_function(level) from dual connect by level <= 1000 ID -- …
User1974
  • 276
  • 1
  • 17
  • 63
3
votes
3 answers

Why does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?

Oracle 18c: I can extract the startpoint X coordinate from an SDO_GEOMETRY using SHAPE.SDO_ORDINATES(1) in a custom PL/SQL function: with function startpoint_x(shape in sdo_geometry) return number is begin return shape.sdo_ordinates(1);…
User1974
  • 276
  • 1
  • 17
  • 63
3
votes
1 answer

Oracle Database 18c installation taking forever to install on windows 10

I'm trying to install Oracle Database 18c locally on my windows 10 pro education but installation is stuck on Creating Oracle XE database even It wasn't allowing to cancel the installation at this point I had to do this through task manager , I have…
mudassir ahmed
  • 191
  • 1
  • 1
  • 13
3
votes
1 answer

Connection pool is never closed with node-oracledb and nodejs

I'm making a little API using Node Js and Oracle, using node-oracledb for that. I have been guided by the following article: API with OracleDB and Node JS The project files contain the following: /services/web-server.js const http =…
luisepa1420
  • 63
  • 1
  • 6
3
votes
1 answer

How can I create an Oracle database in docker, using UTF8 as national character set?

I have created a docker container, containing an Oracle 18 XE instance with a container database and a pluggable database. The application I want to test with this pluggable database requires the database to have national character set UTF8. I can…
George
  • 315
  • 3
  • 15
3
votes
9 answers

Oracle XE 18c create database error "[DBT-50000] Unable to check for available memory" through DBCA

I have just installed Oracle XE 18c on my Windows 8.1 machine. I am trying to create a new database through Advanced Configuration but when I get to Configuration settings step, it throws an error: [DBT-50000] Unable to check for available…
RuxxOather
  • 33
  • 1
  • 1
  • 4
1
2 3
…
21 22