29,193 questions
0
votes
1
answer
57
views
Where to define nested procedures in case when I need - variables + cursors + nested procedures?
I need to add 2 nested procedures into huge existing stored procedure.
But all my attempts fail with different errors.
Unfortunately, I cannot find in Oracle documentation - what is correct sequence ...
- 459
0
votes
1
answer
39
views
Reset APEX User Password [closed]
I am trying to reset the password for my APEX user account. I tried executing and committing the following update:
UPDATE wwv_flow_fnd_user
SET account_locked = 'N' , web_password = 'newpass',
...
- 1,461
1
vote
2
answers
95
views
Issue with compiling PL/SQL: invalid relational operator
Environment Oracle 19c (also 12c)
Here's my code:
CREATE OR REPLACE TRIGGER ClientTime
AFTER INSERT OR UPDATE OR DELETE ON ClientTime
FOR EACH ROW
DECLARE
v_pk_json CLOB;
v_changed CLOB;
...
- 6,191
0
votes
1
answer
40
views
Failed to write to, flush, or close a file. in PL/SQL while trying to write csv file using UTL_FILE
I am trying to create a CSV file of college courses for the current term from a Banner DB (Oracle) using PL/SQL. I’ve created lots of scripts to do this…and no had this issue before.
I’ve spent over ...
- 41
0
votes
0
answers
30
views
Different results when invoking function with raw sql and plsql [duplicate]
Well I have 2 distinct Oracle 12c databases, lets name them db1 and db2
I have a link from db1 to db2 (DBL_DB2), also grants for execution of pkg2 which contains procedure 2, which we call proc2 (in ...
2
votes
3
answers
84
views
Remove empty params from URL
URL like this
https://test.com/test?username=john&x1=1234&x2=5677
I want to remove params if any of them looks like param=.
So for example:
https://test.com/test?username=&x1=1234&x2=...
- 702
0
votes
1
answer
86
views
Unable to pass TO_TIMESTMAP and use filter condition in query oracle
DECLARE
v_sql_stmt VARCHAR2(2000);
v_INSERT_DATETIME TIMESTAMP(6);
BEGIN
SELECT
MAX(INSERT_DATETIME)
INTO V_INSERT_DATETIME
FROM
LOG_TABLE;
v_sql_stmt := '...
- 524
0
votes
2
answers
69
views
Oracle Procedure is not getting invoked
I have a procedure abc(?,?,?,?).
When I'm invoking like below from schema 'pqr' it is getting invoked returning results.
abc(?,?,?,?);
However, when I'm invoking like below from same schema 'pqr' it ...
- 5
0
votes
0
answers
59
views
Call Oracle stored procedure that takes ODCIVARCHAR2LIST parameter from C# using Dapper and Oracle Managed Data Access Core [duplicate]
I'm trying to call an Oracle stored procedure from C# that takes SYS.ODCIVARCHAR2LIST (a table of VARCHAR2) as input parameters.
The procedure works correctly in SQL Developer, but from C# (using both ...
- 4,064
1
vote
2
answers
144
views
Read data from a table in a PL/SQL procedure and insert into another table while one hot encoding
I am trying to read data from a table in PL/SQL through a cursor where I am trying insert the data back to another table but one hot encoded.
So the data is like this:
ORIG_TABLE
ID
Fruit
1
Orange
2
...
- 13
4
votes
1
answer
63
views
Do special characters in LDAP Search escaped by \XX have to be sent in binary form in the wire format?
I am trying to send LDAP Search queries from PL/SQL (OracleDB using DBMS_LDAP.search_s) towards Active Directory for the field objectGUID.
Because that is a binary field, and I need to query non-ASCII ...
- 43
3
votes
1
answer
74
views
Correct syntax to define parameters in a `StoredProcedure` Spring bean, fixing error ORA-06550
Why I am asking this
After upgrade of Oracle JDBC driver in a Spring Boot application from 23.5.0.24.07 to 23.7.0.25.01, all stored procedure invocations in Spring Boot (via StoredProcedure beans) ...
- 27.1k
3
votes
3
answers
173
views
Reduce nested IF…ELSE conditions that iteratively condition building a query by adding filters one by one
My stored procedure has this structure:
if Count 1>0 then
count 2 with (condition 1,)
if Count 2>0 then
count 3 with (condition 1,2)
if Count 3>0 then
count 4 with(condition ...
- 121
1
vote
1
answer
123
views
How to ensure unique index names when creating indexes for FKs with PL/SQL?
I'm trying to write a procedure that automatically creates indexes for foreign keys that don't have one yet. I created a function called SNK_VERIFICA_NOME_IDX which is supposed to ensure the index ...
- 767
0
votes
0
answers
60
views
How to generate access token using serviceAccountKey.json for sending push notifications?
I'm trying to send push notifications using Firebase Cloud Messaging (FCM) HTTP v1 API from my backend server, and I understand that I need to generate a server-to-server access token using a Firebase ...
