All Questions
Tagged with oracle11g stored-procedures
456 questions
0
votes
1
answer
642
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
45
views
Trouble with Oracle Stored Procedure
I am trying to create a stored procedure which takes 1 parameters. I am getting errors when I save below. Any idea? This code is just a small sample run. The length of the whole code is about 1500 ...
0
votes
0
answers
80
views
How to automate Oracle add partition in Oracle 11g
I have begun to work on a new DWH system on Oracle 11g. I don't know application architecture and I would like to know.
I found which tables has partition on year of 2023. I found many tables many of ...
- 69
0
votes
3
answers
120
views
How to write dynamic SQL to select column names based on another table?
I have a use case where I want to write a dynamic sql which would select the column names dynamically based on the other table.
Query 1: select T_SERIES_VALUE from MONTHS_MAPPING where TIME_PERIOD = '...
0
votes
2
answers
671
views
How to handle specific exceptions in Bigquery?
I have used Google Cloud SQL Translation Tool.
How to convert specific errors in Bigquery procedures?
The part 'WHEN ZERO_DIVIDE THEN
some_output := 5000;' in Oracle SQL procedure has not been ...
- 113
0
votes
1
answer
181
views
ORA-01460: unimplemented or unreasonable conversion request
I always encounter this error
ORA-01460: unimplemented or unreasonable conversion request
when I am sending a byte[] of image from stream to my OracleDB.
I even change the parameter direction to ...
- 1
0
votes
1
answer
307
views
Pass object as a parameter to Oracle DB procedure in Express.js and oracledb
I'm trying to execute an SP in Express JS with "oracledb" dependency but when i try to pass the object doesn't work.
This is my type Object
create or replace TYPE ORDER_HEADER_OBJ AS object
(...
0
votes
1
answer
48
views
Can I use "order by" with user input in oracle?
I use the same procedure for several tasks. Each function also needs to use ORDER BY every time.
I want to use ORDER BY with user inputs.
I tried this but it didn't work.
PROCEDURE ...
user20507126
0
votes
2
answers
64
views
Retrieving the highest varchar value
We are using the Oracle database.
I have a table with the below records
OrderNumber
-----------
JK-PO-01
JK-PO-02
JK-PO-03
Using PL/SQL, I would like to get the latest order number (JK-PO-03)
I tried ...
- 27
0
votes
0
answers
156
views
Finding the creator of the stored procedure
I am with an organization where people can create stored procedure for the same schema.
Is there a way I can find out who created the stored procedures?
Thanks!
- 1,548
-1
votes
1
answer
74
views
How can I convert a small query from SQL Server to Oracle, I don't know how to apply their equivalents in reserved words?
I have always worked with SQL Server and now I want to learn Oracle, how can I convert this little query from SQL Server to Oracle?
I have errors in this query:
with cte as, OFFSET @start ROWS FETCH ,
...
- 45
0
votes
2
answers
571
views
Stored procedure with select count(*) and use count in IF statement
I am creating a stored procedure in Oracle database that's resulting in error "ORA-01858: a non-numeric character was found where a numeric was expected".
My procedure is as below:
create or ...
0
votes
4
answers
2k
views
SELECT INTO STATEMENT INSIDE A SQL PROCEDURE THROWING AN ERROR
Hi I want to store a avalue of select statement into a variable and then update my table using that variable within the procedure but there is an error . I still dont know its only returning one ...
- 44
0
votes
1
answer
269
views
SYS_REFCURSOR as output parameter in a function
I have a function like below. How do I print the output for this function. I tried something below. But its throwing too many values error
CREATE OR REPLACE FUNCTION PMDB_POSTGRES.Fn_test
(
...
- 147
0
votes
2
answers
154
views
How to call stored procedure that returns 1 row?
How to call a procedure in C# to return 1 row only?
When I run this code I wrote, I get this error:
ORA-06502 :PL/SQL: numeric or value error
Code:
con.Open();
OracleCommand comm = new ...
- 21