Questions tagged [oracle]
Oracle Database is a Multi-Model Database Management System created by Oracle Corporation. Do NOT use this tag for other products owned by Oracle, such as Java and MySQL.
oracle
152,123
questions
0
votes
0
answers
5
views
Oracle: Error when compiling any stored procedure . WaitCursor.hide called without matching WaitCursor.show sql developer
I created a new Oracle RDS from an existing snapshot. But when I try to compile any existing procedure I get this error on SQL Developer :WaitCursor.hide() called without matching WaitCursor.show().
...
0
votes
2
answers
6
views
ORA-22921: length of input buffer is smaller than amount requested
While I was working with a table containing a BLOB column:
SELECT id FROM table WHERE blob_column LIKE '%something%';
...I got the following error:
ORA-22835: Buffer too small for CLOB to CHAR or ...
- 10.2k
-2
votes
2
answers
15
views
Oracle regexp_replace entire matching word
Input:
ABC DEF GHIJ123A KLM GHIJ456B RST UVW GHIJ789C
Ouput:
ABC DEF GHIJ000X KLM GHIJ000X RST UVW GHIJ000X
So, I want to find all instances of words in the string that start with GHIJ and replace ...
0
votes
0
answers
11
views
python-Oracledb module not working in AWS Glue
I am trying to connect to my on premise Oracle database using oracledb library in AWS glue.
import oracledb
connection = oracledb.connect(user="my user", password="mypass",
...
- 61
0
votes
1
answer
31
views
ORA-02020: too many database links in use
I have been working on a oracle database query that uses more than 4 database links and I keep getting this error ORA-02020: too many database links in use.
I cannot change the limit and tried using ...
0
votes
0
answers
11
views
JPA @Procedure multiple out parameters
Here is my working code:
public interface CandidatRepository extends JpaRepository<Candidat, String> {
@Procedure(procedureName = "garnuche.INSCRIPTION_TEST")
...
- 2,690
0
votes
0
answers
16
views
How to execute SQL statements against on premise Oracle DB in AWS Glue
I am trying to update a table in my Oracle DB using AWS Glue. I know that PySpark is not really meant for updating tables or inserting. More for reading. Though, I am trying to update all rows for a ...
- 61
1
vote
2
answers
47
views
INSERT and UPDATE the Values into the table based on condition
I have 2 tables:
Table 1: EnrollmentTransaction (PK is both the column)
EnrollmentId | TransactionId
-------------+--------------
5 | 1
5 | 2
6 | 3
7 | 2
7 ...
- 55
0
votes
1
answer
23
views
Invalid Identifier error while using standard_hash function in oracle 11g
I'm trying to generate a hash based on a field but got the following error:
Query:
select standard_hash(pk_time) from schema.table
Error:
"STANDARD_HASH": invalid identifier
The column type ...
- 10.2k
1
vote
1
answer
35
views
How to effectively "remove" clauses from a query, if no params are provided [duplicate]
I am trying to query some data as part of an APEX form and if a value isn't supplied I basically want to remove the clause for it entirely, or effectively nullify it.
So, let's say I have this query
...
- 5,433
-1
votes
0
answers
33
views
Group function not allowed here [closed]
I am trying to get the count of distinct c.deal_no and use this value in my further calculations, but I get an error.
This is my query:
Select
a.Oa_Permid,
a.NAME,
select
count(...
- 3
0
votes
0
answers
8
views
Oracle autonomous db update api not working
TypeError: Cannot read properties of undefined (reading 'longTermBackupSchedule')
at getJsonObj (/home/ubuntu/work/OCI-CloudKIT/node_modules/oci-database/lib/model/update-autonomous-database-details....
- 1
0
votes
0
answers
31
views
How to return lowest result from sequence column
I'm new to learning oracle sql, so I'm sure this has a simple solution that I'm missing, but I'm trying to return the first sequence row from each order, not just limit the whole query results to 1 ...
- 65
1
vote
1
answer
24
views
Adding Column Names to Oracle SQL VBA Export
I wrote the following VBA code to connect to an Oracle SQL database and run a query, then export to a new Excel workbook. The query is returning the correct information, but is not returning the ...
- 11
0
votes
2
answers
25
views
Oracle SQL Query To Calculate Length of Service For Employees With Multiple Termination and ReHire Dates
I am trying to calculate the length of service of our employees within our Oracle database. Below is a table with some example data for two employees. The calculation would be from the first HIREDATE ...
- 57