29,156 questions
Score of 0
0 answers
51 views
Add error message to stack if apex_web_service.make_request fail
In Oracle apex, I have a page with SUBMIT button. On page submit, following happens
Execute "procedure_do_call"
'procedure_do_call' makes a REST API call using apex_web_service....
- reputation score 609
Score of 1
2 answers
201 views
Calculate customized ASCII values without using Loop/Cursor
I want to convert the following loop based query (from Oracle) to a set-based query (to PostgreSQL) without using Loop/Cursor.
The following code used to calculate/generate numeric values for the ...
- reputation score 7411
Best practices
0
votes
4
replies
109
views
How can I shorten an Oracle SQL Union All query in which most elements are the exact same?
I'm working with Oracle SQL 20.2 and writing a PLSQL procedure. The main body of the procedure is a Select query in which I make use of UNION ALL to get rows from two different tables that join onto ...
- reputation score 73
Advice
1
vote
4
replies
145
views
How to return correct record if multiple records have same value in oracle sql
From_step
To_step
Step
4210
0088
B234210
0088
4210
B240088
4210
4600
B234210
As you can see my table above, 4210 returns twice which has multiple record, so in my case it returns B234210 twice, by ...
- reputation score 1
Advice
1
vote
4
replies
96
views
I need to pass changes on certain tables to external system but am worried not to skip anything
I need to pass changes on a table to external system. Let's say I have table of messages. I have a column called change_id which is populated by trigger from a sequence on insert and update. ...
- reputation score 113
Advice
1
vote
5
replies
179
views
Oracle, PL/SQL and Java
I’m a PL/SQL developer with strong Oracle experience, interviewing for a role in a Java-based team. They’re happy with my database skills but want me to learn few Java skills before the next round.
...
- reputation score 19
Score of 4
1 answer
79 views
Oracle 19. date century. difference in behaviour between 2 updates
I update 2 different columns within the same update and with the same variable (a date with value "01.01.1900"), the first one get the right value, the second one gets "01.01.2000"....
- reputation score 41
Score of 1
0 answers
178 views
Passing an array to a stored procedure expecting a SYS.ODCIVARCHAR2LIST
I'm passing an array of strings to an Oracle PL/SQL stored procedure to a parameter that expects SYS.ODCIVARCHAR2LIST on my muleApp stored procedure connector and it throws the following error:
ORA-...
- reputation score 33
Score of -1
2 answers
259 views
Refactor Stateful/Loop-based approach into Set-based approach
I have the Oracle Pipeline function, which is used to allocating marketing budget across product groups and campaigns.
This will allocate a total marketing budget to various campaigns within product ...
- reputation score 7411
Best practices
0
votes
3
replies
62
views
PL/SQL elegant Solution for HTML-User Input
I got a Web Form that is capable of displaying some data to users and reading some user input back into the database. However, I need a ton of parameters to work with, and as the project grows, I ...
- reputation score 376
Score of 1
1 answer
104 views
Call to an overloaded procedure inside another procedure in an Oracle/PLSQL package
I have a question about this package:
create or replace PACKAGE BODY emp_pkg IS
FUNCTION valid_deptid(p_deptid IN departments.department_id%TYPE)
RETURN BOOLEAN IS
v_dummy PLS_INTEGER;
...
- reputation score 22
Advice
1
vote
4
replies
104
views
Check valid identifier name in Oracle
The database tool in IntelliJ can detect if an identifier needs to be quoted to make a statement work.
If I use a valid table name, the quotes are removed.
How can I do the same?
The best would be a ...
- reputation score 1253
Score of 1
1 answer
131 views
Render page item which has HTML in Oracle Apex
I have an application where I need to display and stylize the heading of the region. So instead of display heading simply as "Car", I need to display "car icon Car". This icon and ...
- reputation score 609
Score of 0
1 answer
223 views
Error when calling dbms_cloud.export_data
I'm trying to do my first CSV export into an existing AWS S3 bucket. Calling with type CSV:
call dbms_cloud.export_data(credential_name => 'cred', file_uri_list => 'https://s3.us-east-2....
- reputation score 1
Score of 0
1 answer
110 views
Oracle sql. how to check file existence on remote server
I'm trying to check if a file exists on a remote server, in a Forms 12c program unit.
I tried to use
utl_file.file_exists('\\server\d$\folder\filename.txt')
and also
utl_file.fgetattr('DBFOLDER','...
- reputation score 33
