All Questions
Tagged with stored-procedures plsql
1,825 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
62
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
73
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
-1
votes
1
answer
45
views
Multiple tables as output parameters in Procedure using hibernate
CREATE OR REPLACE PACKAGE BODY Pkg_name
IS
PROCEDURE proceure_Name (
Id IN Long,
startDate IN DATE,
EndDate IN DATE,
Table1 OUT Table1_Name%ROWTYPE,
Table2 OUT ...
1
vote
0
answers
31
views
Calling stored procedure with Hibernate which multiple type of outputs
I have a stored procedure from my DBA team. Here is the stored procedure, and temp table created. All I want to know here, how to map the temp table to the output value while calling the procedure in ...
- 11
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
648
views
SQL Error [900] [42000]: ORA-00900: invalid SQL statement
I'm working on a Oracle stored procedure , my oracle database version is Oracle Database 11.2.0.1.0 , I'm very familiar with MySQL and SQL Server as well but I am really new to Oracle, I tried to ...
0
votes
1
answer
235
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
