Latest Questions tagged Oracle

Browse all latest questions tagged Oracle

Published 27 Oct, 2022
Java - How to use different tablespaces for tables and indexes with liquibase in Java

I'm using liquibase (3.6.3) in Spring Boot (2.1.8) java (1.8) application for managing database (Oracle 12.2) schema changes. My liquibase changesets does not contain 'tablespace' params and all data...

Published 03 Aug, 2022
Jquery - Disable button programmatically in oracle apex using javascript/jQuery

I'm trying to disable a button inside of a form region in Oracle Application Express (Apex v3) in an ajax-ified manner. I'm using jQuery to accomplish the ajax part. $('#P16_MYBUTTON').hide(); D...

Published 23 Aug, 2022
Java - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this:

Published 03 Jun, 2022
Python - cx_Oracle connection fails with 'DPI-1047: Cannot locate a 64-bit Oracle Client library'

Problem use connection oracle to python source, oracle now is worked to other language php (oci) Error: Traceback (most recent call last): File "c:\xampp\htdocs\pyoracle\

Published 24 Aug, 2022
Python - Python 3.3 - Connect with Oracle database

Is there a module for python 3.3 to connect with Oracle Databases? Which is the easiest to use? Something like the mysql module, only works with Oracle. Preferably version 10g, but 11g will do just f...

Published 05 Sep, 2022
Java - SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I am trying to develop a Java EE application that connect to an Oracle database from eb service class but I encounter a SQLException: No suitable driver found for jdbc:oracle:thin:@//localhost:1521/...

Published 05 Sep, 2022
Java - JPA CriteriaQuery compare Timestamp ignore time portion

Let say I have a column in Oracle DB like this: SOMETHING_TS TIMESTAMP WITH TIME ZONE And I would like to use CriteriaQuery to filter by this column. I can used native query to achieve this:...

Published 31 Aug, 2022
Java - Oracle Store Procedure with BLOB parameter

Hi i'm new working with this technologies (Oracle SP ), so I have some problems with it, To be specific I want to insert a BLOB object over a Store Procedure, currently I work with spring, jboss, jav...

Published 16 Apr, 2022
Javascript - Javascript date to sql date object

I'm trying to write a query that takes a Javascript date object and then puts it in an object type that is recognized by both SQL Server and Oracle database types. The issue is that I'm using webserv...

Published 02 Sep, 2022
Java - "java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver" error when running from terminal

I have a program that I run from Eclipse successfully. However, when I want to run it from terminal, I encounter the famous error: "java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriv...

Published 01 Sep, 2022
Java - Get Sequence Name (Oracle)?

I don't have access to see the database, but I have the ability to create database objects (via an xml file). The xml documentation says that if I set an attribute called "identity" to true then a seq...

Published 29 Aug, 2022
Java - What is causing a unique constraint violation when using a SEQUENCE in Hibernate?

I am using the code below to generate unique IDs for an id field. It was working fine until last week. I deleted some entities using the Hibernate interface and then it started giving a unique constra...

Published 28 Aug, 2022
Java - Invalid operation for read only resultset: updateString

Following is my code(Re-constructed) which select & update STATUS field depending upon the conditions. (Using Servlets, Oracle as Backend and JDBC driver) ResultSet rs=null; String query = "selec...

Published 07 Sep, 2022
Java - How to set java.library.path when install oracle 18c on CentOS8.2?

I was installing Oracle 18c rpm on CentOS8.2, after yum install oracle-database-ee-18c-1.0-1.x86_64.rpm and begin to configure by using "/etc/init.d/oracledb_ORCLCDB-18c configure" command,...

Published 06 May, 2022
Python - Can I use SQLPlus to execute a .sql file?

I have a .sql file with the following code: delete from stalist where stalistid=4944 / insert into stalist (stalistid, staid) (select distinct 4944, staid from staref Where staid in( 3797,3798, 3870,...