Questions tagged [plsql]
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL. Questions about PL/SQL should probably be tagged "oracle" as well. Questions with regular DML or DDL statements should be tagged with "sql" and "oracle", NOT with "plsql".
plsql
29,085
questions
-1
votes
0
answers
12
views
Update statement in trigger [closed]
I have to write the update statement in existing trigger.i have to write the update statement after calling the procedure,the update statement will be in update the value with new value that is ...
0
votes
0
answers
9
views
How to post multiple objects in oracle apex rest api?
I am trying to post data like below
{
"ORG_ID": "81",
"TRX_DATE": "30-JAN-2024",
"TRX_NUMBER": "240006078&...
0
votes
0
answers
12
views
utPLSQL CLI throwing multiple no_data_found [-01403] instead of passing test with --%throws(xxxx)
I'm writing unit tests with --%throws() and they are passing in the schema, but when running through utPLSQL CLI [Jenkins plugin], I'm getting multiple no_data_found [-01403] errors and tests fail as &...
1
vote
1
answer
39
views
Loading CSV files with double quotes in field values via Oracle Loader External table
Requesting your help and expertise on the below:
Oracle DB 19c on UNIX server
Requirement:
CSV files come in on a daily basis in a Unix directory (where the database resides) and gets loaded to a ...
3
votes
1
answer
57
views
Find Source, Join, Subquery Tables from a PL/SQL code using python
I have a plsql code,
I want a python code which will help me to find source, join and sub query tables and subquery join tables. Kindly consider that the plsql code would get changed according to the ...
0
votes
1
answer
32
views
Why the Cursor query is fetching records successfully but not fetching the values?
Below is the SQL package which is going to be a part of a script. In this package the cursor used is fetching sufficient records as required, but not working when I am incorporating in this package. ...
0
votes
1
answer
19
views
ORA-06530: Reference to uninitialized composite when using schema-level type
I created a record and a table of records on the db schema the following way :
CREATE OR REPLACE TYPE WS_RESPONSE AS OBJECT (
valeur VARCHAR2(1000 CHAR)
);
CREATE OR REPLACE TYPE WS_RESPONSE_TABLE ...
0
votes
0
answers
14
views
Dynamically display column in B page based on the display_type in A page in oracle apex 23.1.1
In Oracle Apex. There are two pages A and B
In A we will create datapoints which becomes a column in page B to achieve this we have created page items for all the columns of page B and synced it with ...
0
votes
1
answer
33
views
Fill up schema-level table, and use it with join
I have a schema-level record type and a schema-level table type, and I want to fill this table with records.
create or replace Type t_SLRekord As Object(OWNER VARCHAR2(128),
...
0
votes
1
answer
50
views
How to loop through multiple cursors in succession in PL/SQL
This is probably simple but I cannot find a good example online. I have 5 cursors I would like to iterate through in succession (loop through all of cursor 1, then loop through all of cursor 2, etc). ...
-1
votes
1
answer
33
views
I have a scenerio to update a table data
I have a table with colums and data as follows
id from_date to_date value change_date
10 jan-2021 dec 2021 100 dec-2021
10 jan-2022 dec 2022 100 dec-2022
10 ...
0
votes
1
answer
11
views
`apex_json.get_VARCHAR2(p_path=>'w',p_values=>apex_json.g_values)` function return null
I have situation of building json using apex_json as the code sample explain it. the problem is that apex_json.get_varchar2('w') return null, even after I checked the apex_json.g_values. any one could ...
0
votes
1
answer
31
views
Oracle DB function to display with date manipulations
I have created a PL SQL function to calculate amount based of rates stored in the database for different period, The function is supposed to iterate through given month and get the rate of each month ...
0
votes
1
answer
47
views
Managing PL/SQL Jobs to Avoid Deadlocks on a Large Table
I have a PL/SQL procedure that submits jobs in a loop, processing different parameters (branches). Each job performs inserts and updates on a large table. Due to the size of the table, a table lock is ...
1
vote
1
answer
27
views
Oracle Hierarchical query with multiple Parent Levels : how to get required details
I have a table which stores Hierarchy of Customers i.e., GrandParent, Parent and Child as follows
CustomerNum Amount GrantParent Parent
----------- ------ ----------- ------
...