All Questions
Tagged with oracle stored-procedures
3,958
questions
0
votes
1
answer
41
views
Two PUBLIC Views in Stored Procedure - One Succeeds, One Errors?
If user A creates a view and grants READ on it to PUBLIC.
SQL>create view A.a_public as select 3 id from dual;
View created.
SQL>select * from A.a_public;
ID
----------
3
SQL&...
-1
votes
0
answers
32
views
POWER BI with Stored Procedures
How to connect power bi to oracle stored procedure, so that the result as an output refcursor from my procedure shall be used to visualize the data as a chart in power bi
0
votes
1
answer
41
views
How to check if input parameter of timestamp type in oracle stored procedure is null?
We have an oracle stored procedure which accepts multiple timestamp input parameters. This stored procedure is invoked from typescript.
So, when typescript invokes this stored procedure, there is high ...
1
vote
0
answers
32
views
How to use User Defined Type(UDT) in dapper for oracle databse
I have a UDT like
CREATE OR REPLACE TYPE VList AS TABLE OF VARCHAR2(100);
and this is my stored procedure;
CREATE OR REPLACE PROCEDURE SEND_EMAIL_PROC
(
P_EmployeeIds VList,
P_DeptsIds VList,
...
0
votes
2
answers
67
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
0
answers
37
views
Can we call Oracle stored procedure and pass parameters from CSV file using Liquibase
Using liquibase, I have tried loading data in a table using the following and all is working fine
<changeSet author="your.name" id="04::dataForTable" labels="data">
...
0
votes
2
answers
59
views
How to insert records from table A to table B, avoiding inserting records from table A that already exist in table B
My table 'B' is the table where the data will be definitely stored without having repetitions while table 'A' is created to store any information including repetitions, this can happen because the ...
0
votes
1
answer
44
views
Getting Invalid Identifier error of ORA - 00904 even when column name is same
I have used with statement to bring and fetch data in a procedure but while executing it I am getting error as
Error(550,37): PL/SQL: ORA-00904: "Q2_DATA"."AR_LENGTH": invalid ...
0
votes
1
answer
60
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
31
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 ...
-1
votes
1
answer
53
views
How to enter cursor as an input in procedure oracle [duplicate]
I want to create a procedure that uses cursor as an input in Oracle. I tried something like this:
cursor cur is select * from table t1;
and then also:
create or replace procedure (I want to input ...
0
votes
1
answer
51
views
Oracle stored procedure not executing and throwing error
I have a stored procedure where I am merging two queries to get the results. But I am getting this error:
Error(331,2): PL/SQL: ORA-00933: SQL command not properly ended
This is the query:
SELECT
...
0
votes
0
answers
42
views
How to call a stored procedure (Oracle SQL) with variables filtered in a dashboard in PowerBI
(Edit: I rewrote my question and hope that it become clear what I want to do this in PowerBI)
I'm new to PowerBI and I would like to use it as visualization for my stored procedures which are in an ...
0
votes
0
answers
13
views
SSIS OLE DB Command Calling Oracle Stored Procedure - How to capture Ouput Parameter
In Visual Studio 2022, I'm using an OLE DB Command to call a Stored Procedure.
If my stored procedure just has Input parameters, it works fine - I can pass the parameters with the '?' syntax (eg ...
0
votes
1
answer
108
views
Cannot execute stored procedure in Oracle19c
I am currently facing an issue(below is the error code) when trying to import data from a .csv file to OracleDB. Now, I have a stored procedure so that I could easily call it out. Now, every time I ...