All Questions
1,516 questions
0
votes
1
answer
41
views
Oracle: calling a procedure via DBLINK does not rollaback to savepoint in tables that are over another dblink
i have a 19c installtion and i'm trying to understand why somedata i still written when i use a savepoint. One database is a non-CDB (DB1) and the other is a PDB (PDB2). Each databases have dblinks to ...
- 23
0
votes
1
answer
57
views
PL/SQL JSON_OBJECT_T error Code: -40573 - ORA-40573: Invalid use of PL/SQL JSON object type
I'm trying to build one PL/SQL stored procedure to insert update delete data into the table using below procedure but it is failing with the error Error Code:
-40573 - ORA-40573: Invalid use of PL/...
- 97
0
votes
2
answers
63
views
JSON with °(degree) sign / special character is not sent to API as expected
I am using the above code in Oracle, to send a payload to an API. It's working for all the payload except when the comment field has a Degree sign(°).
/////////////////////////////////////////////////...
3
votes
2
answers
108
views
Return multiple ref cursors in single OUT parameter of stored procedure
For the procedure below, I need to return the resultset of multiple dynamic queries into a single refcursor or any other type of output parameter.
Please note that in my project, I may have more than ...
- 47
0
votes
2
answers
74
views
How to execute a dynamic sql using a variable inside a procedure
How to execute a dynamic SQL in a stored procedure which uses a variable which is defined as a first day of the month.
Consider this just an example
Declare
V_frst_day date date :=to_date('01-feb-||...
- 33
0
votes
2
answers
41
views
Creating a Procedure using Merge Into’ but getting Syntax Errors SQL Developer/DBVisualizer
I have 5 tables in total. I wrote the initial sub query to gather the proper Pace IDs/Product IDs according to the Master Product ID. However, when I go to join to the Status/Record Tables in my ...
- 13
-1
votes
1
answer
40
views
plsql loop with a procedur
i have this loop with a procedur, but its run in a error:
ORA-06550: line 18, column 9:
PLS-00103: Encountered the symbol "CELLNEX_HI3GNY2017" when expecting one of the following:
:= . ( @ %...
- 13
0
votes
2
answers
84
views
Trying to execute a simple stored procedure - Help! Can't find an answer that works here
I'm completely new to SQL and am trying to execute a stored procedure that I'm not even sure I wrote correctly. It's supposed to give the total number of patients for a given dr, and this is the ...
0
votes
1
answer
236
views
Error occurred during update: ORA-01403: no data found when using update in forall in stored procedure in Oracle
Below is the stored procedure I have created. It is the "Create" stored procedure. I am getting error while updating the data.
SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE ...
0
votes
1
answer
32
views
Based on a min and max id obtained from a table, how to calculate how many groups of records I can divide the information intoo
In a table I have 300 records of which I am going to use those rows that have been modified with today's date.
Through a query I obtain a Minimum ID and a Maximum ID
For example, if I modified rows ...
-2
votes
1
answer
76
views
Oracle procedure giving multiple syntax errors
I have written a stored procedure to update 2 tables with some IF ELSE conditions. But while compiling the full procedure I am getting syntax error:
Error 1:
Error(1115,1): PLS-00103: Encountered the ...
- 4,737
0
votes
2
answers
107
views
Best pl/sql strategy to return a single output row of a concatenated list within a list
I have the following data sample below.
User Levl Clan Skills WpnCode
Sam 100 Daredevil Beginner
Sam 100 Daredevil ...
- 396
0
votes
2
answers
274
views
Getting ORA-01422 error when only one record exists with condition
I am attempting to select data in an Oracle PL/SQL procedure. When I select the data from the table directly like this
SELECT * FROM CUSTOMER_USERS
WHERE customer_id = 'cust1234'
AND user_id = '...
- 1,296
0
votes
3
answers
366
views
ORACLE: Build 'INSERT INTO' statements from 'SELECT *' results
I am trying to build a script that takes the results from a table "ADMIN.ACCT_HRS" and creates INSERT INTO statements for each row, so that I could feasibly rebuild the table on another ...
- 11
0
votes
1
answer
39
views
What is a actual meaning of procedure?
SQL> create or replace procedure print()
2 is
3 begin
4 dbms_output.put_line("This is a print procedure");
5 end;
6 /
Warning: Procedure created with compilation errors.
...
- 11