All Questions
41 questions
-3
votes
1
answer
56
views
Using DECLARE in stored procedure for Oracle results in syntax error
create or replace PROCEDURE "SYNC_EMPLOYEES_WITH_HR" (
EMPLOYEE_NUMBER IN NUMBER
) AS
Declare middle_initial varchar(200);
Declare first_initial varchar(200);
Declare last_initial varchar(...
- 7,635
1
vote
1
answer
6k
views
PLS-00320: the declaration of the type of this expression is incomplete or malformed while creating Procedure [closed]
Below code is to create a procedure passing some values and then an insert operation happens in_no_tiers times
CREATE OR REPLACE PROCEDURE INSERT_TIER_INFO(in_lp_code IN VARCHAR2 , in_tier IN VARCHAR2 ...
- 625
1
vote
1
answer
118
views
PL/SQL Block Finding number of suppliers for each nation
I'm still new to PLSQL and am currently using TPCH Dataset to practice. I have been trying this for a while not but I can't seem to wrap my head around it and could use some advice. A rough overview ...
- 13
0
votes
1
answer
69
views
sql query to pl sql procedure
this is my requirement .i want fetch the record from one table and store it in another temporary table.i wrote as query.but dont know how to make it as procedure by declaring varibales and so.
Daily ...
- 37
0
votes
2
answers
2k
views
Oracle stored procedure that can auto remove records after 24 hours
Can a procedure auto triggered after 24 hours and remove records from a specific table?
I tried, but as a beginner I'm not able to do it.
Here is my code:
CREATE OR REPLACE PROCEDURE deleteresetlinks (...
- 1
-1
votes
1
answer
381
views
how to conver this Pro*c query into plsql procedure?
'''
select_wk910_exist()
{
/* changes done for k3 */
MEMSET(wk910_exist_ccno);
EXEC SQL SELECT CARD_CUST_NO INTO :TAB1_exist_ccno FROM TAB1
WHERE APPLN_BATCH_NO!=:app_batch_no
AND ...
- 1
0
votes
0
answers
76
views
ORA-20000: ORU 10027: Buffer overflow,limit of 20000 bytes [duplicate]
We have an oracle SP where it is using many dbms output to print the result set. Due to this the procedure is only executed partially and throws error message ORA-20000: ORU 10027: Buffer overflow,...
0
votes
2
answers
474
views
ORA-00907: missing right parenthesis and ORA-06512: at line 16
For the below procedure I am getting the ora error as mentioned in the title while running in Oracle SQL developer
DECLARE
sqlstr VARCHAR2(1000);
CURSOR TabSubPartitions IS
SELECT TABLE_NAME, ...
- 45
0
votes
1
answer
310
views
PL/SQL error with cursor, ERROR ORA-06550
I'm studying PL/SQL and I'm trying to create a procedure, but I'm having problems with the cursor and I don't know what it is, if you can help with my code I'll be grateful.
take a look in my code
...
1
vote
2
answers
317
views
Is there a way to embed an alter query into a oracle sql procedure?
I am trying to create a procedure that I can call upon that would alter the date format and I am having some issues and could use some help.
If I try this code:
create or replace PROCEDURE ...
- 682
0
votes
3
answers
43
views
Is there any faster way to perform merge on 120k records weekly in oracle pl/sql?
There are around 120k records in the database, and based on a few functions I calculate scores for all the records, weekly I have to update the table with new records and respective scores.
Below is ...
- 87
1
vote
1
answer
451
views
PL/SQL change value in 1 row in procedure
i do not know where the bug is. I must write the procedure where the 1 specific row will be chaned. Everytime i lunched it, wrote me:
Errors: PROCEDURE RENAME_FLYTICKET Line/Col: 1/65 PLS-00103:
...
- 91
1
vote
3
answers
22k
views
How to fix Character string buffer too small error in OUT variable in Stored Procedure
I`m trying to use OUT variable to send a SQL result but I received "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error, I try to change o_sql from varchar2 to ...
0
votes
1
answer
66
views
Multiple Records being fetched in Cursor PLSQL Procedure
Table : WSH_DEL_DETAILS_INTERFACE
Unique Column:DELIVERY_DETAIL_INTERFACE_ID
Input to procedure : DELIVERY_DETAIL_INTERFACE_ID
Column values to be fetched:SALES_ORDER_LINE_NUMBER , ...
user7755218
0
votes
1
answer
15k
views
Create Procedure with no Parameters
Its my second time writing procedures and this one is the first time I have to use a cursor. For this procedure I am not expected to use parameters but Im having problems with it. This is what I ...
