All Questions
154 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
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
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
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
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
395
views
warning execution completed with warning stored procedure
i wrote a stored procedure in oracle sql developer to be used later in .netframework app
compiling the stored procedure gave me this message
Warning: execution completed with warning
procedure ...
0
votes
0
answers
277
views
PLSQL: CLOB data returns ORA:06502
Querying a clob column through native dynamic sql is not working as expected, does dbms_lob.substr has any limit while its used in native dynamic sql? Any suggestions on how can I run with dbms_lob....
- 1
0
votes
2
answers
111
views
Pl/Sql Script for update more than 1 000 000 rows
I have a table:
id| name | organisation_name|flag |priority|salary
1 | Mark | organisation 1 |null |1 |100.00
2 | Inna | organisation 1 |null |2 |400.00
3 | Marry| organisation 1 |...
- 73
0
votes
2
answers
274
views
Stored procedures in Oracle databases (11g)
I've been struggling with this for a while.
I want to create 3 different stored procedures but i am not very sure
about the syntax and how to execute them in Oracle database (version 11g)
My table ...
- 823
0
votes
2
answers
714
views
How to restrict any DML operation in a stored procedure
I am trying to insert some records into a table for a particular month. How do I restrict any DML operations on that table for rest of the other months in a stored procedure (without any trigger or ...
- 27
0
votes
1
answer
1k
views
`Invalid Character Error `while executing oracle procedure using `getclobval()`
The following procedure compiles successfully on ctrll + S (shows VALID) but on execution throws the error : Invalid character error while executing this procedure on SQL DEVELOPER.
I don't see ...
- 789
0
votes
1
answer
43
views
Oracle cursor for dynamic query
I have an SP that tries to execute a cursor for a dynamic built query
Here is the code
procedure echeancnew(p_entity in varchar2,
ref_data OUT ref_cursor)
as
...
- 1,436
0
votes
3
answers
54
views
provide Select statement in procedure parameter
Hi i'm working on this query in oracle and i need to provide many id to a procedure from a table. how can i provide each id from a table to my procedure. sory i'm kinda new at this im completely lost ...
