A PL/SQL package is a schema object that groups logically related PL/SQL types, items, and subprograms. Use this tag for questions referring to the PL/SQL packages usage and behaviour.
Questions tagged [plsql-package]
240 questions
0
votes
1 answer
Oracle trying to update a table with data with a count values
the below code doesnt complete as im trying to update a table with 2500 000 rows.
Please see code below and advise what could be the issue, and how I could improve the performance so the update can be completed.
begin
open C5_CUR;
loop
FETCH…
Sihle Ndaba
- 11
- 1
0
votes
2 answers
How to improve the pl-sql Procedure code, 2 hours for 100k records
How to improve the performance on below code? It takes 2 hours for 100k records.
create or replace PROCEDURE APO_RMS_E_PRIO_ITEM_REPL_P
AS
O_error_message VARCHAR2(2000);
L_program VARCHAR2(100):=…
user81157
- 1
- 2
0
votes
0 answers
where do I find Oracle Subtype in system Tables?
I have created a package in oracle database with type and subtype. When I am trying to see the types and subtype in "ALL_TYPES" or "ALL_PLSQL_TYPES" i am able to see only type details but not subtype details. Where can i find subtype details in…
0
votes
1 answer
How to open, read and store to DB content of XLSX file with PLSQL?
I am trying to Open, Parse and save to Database the content from .xlsx file using PLSQL. Is this possible ? I have my files on the server, created the object for that path and gave rights rw for my user. Should I convert from XLSX to CSV using…
Adi
- 311
- 4
- 19
0
votes
1 answer
How to use PL/SQL in making the subject line of an email package variable?
How can I make a variable subject of an email using PL/SQL?
Currently, I am using a constant string as the subject:
'Open Action items for review'
I need to modify it to:
'Open Action items for review Day 5' -> If the action item is on 5th day…
Amrita06
- 1
- 3
0
votes
1 answer
what is the best way to get result using the below query
Following query does not show any output but it does not have any errors -
select inv_id
from invoice_table
where
INVOICE_DATE BETWEEN to_char(P_INVOICE_START_DATE,'DD-MON-YYYY')AND to_char(P_INVOICE_END_DATE,'DD-MON-YYYY');
Where did I go…
Testimony
- 11
- 6
0
votes
1 answer
How do you add cursor into a procedure in PL/SQL block?
I need to create a procedure that accepts first and last letter of a person's name and returns the totalcost and total items bought by him. I have no idea how to use the cursor with it also i'm thinking i have to use a for loop and exception…
0
votes
2 answers
What is wrong in the program?
Ihave created procedures in a package... While compiling in TOAD, there were no errors but after submitting my jsp page it is showing that
""package body "USERINFO.FORM_PKG" has errors ORA-06508: PL/SQL: could
not find program unit being called:…
mayukhsroy
- 141
- 1
- 1
- 9
0
votes
1 answer
how to use wildcard in renaming file in oracle directory
Is it possible to use wildcard on renaming a file from a directory?
UTL_FILE.FRENAME (
'EXT_DIR' IN VARCHAR2,
'%.CSV%' IN VARCHAR2,
'EXT_DIR' IN VARCHAR2,
'WPP_ACCOUNT.CSV' IN VARCHAR2,
TRUE);
Nick
- 117
- 1
- 9
0
votes
0 answers
external table preprocessor is not working
--the preprocessor is showing as an error when in sql developer oracle 12G
CREATE TABLE WPP_EXT (
ACCOUNT_ID VARCHAR2(50),
SER_NUM VARCHAR2(100)
)
ORGANIZATION EXTERNAL (
TYPE ORACLE_LOADER
default directory EXT_DIR
access…
Nick
- 117
- 1
- 9
0
votes
1 answer
How to loop G_FXX where XX = (01,02..n) in Oracle Apex?
Basically what I want to achieve is looping through G_F0X array to make my code more compact without using for example:
APEX_APPLICATION.G_F01(1);
APEX_APPLICATION.G_F02(1);
APEX_APPLICATION.G_F03(1);
For sure, it's not working but I can't find any…
Adi
- 311
- 4
- 19
0
votes
1 answer
PL/SQL Functions in collection type
So I've created an object type with several attributes.
And from that object I've also created a collection type.
Let's say:
create or replace type employees as table of employee;
Now I want to use the collection object to perform methods such…
Xepos
- 167
- 1
- 15
0
votes
1 answer
Error on sysdate and does not compile
I have a sample pl/sql that does not compile. i have 4 errors and cannot figure out where it is. i have attempted process of isolation and yet i cannot find out the missing piece
CREATE OR REPLACE PACKAGE TestLocks AS
PROCEDURE…
junkone
- 1,427
- 1
- 20
- 45
0
votes
2 answers
using nested table as in Parameter to a Procedure
I have a table T1 and I want to insert multiple rows at a time through a procedure using collection. I have written the code but when I'm trying to execute it throws an error. Please advise.
create table t1 ( id number , name…
kashi
- 61
- 1
- 12
0
votes
1 answer
Global Variable in plsql
I have created one package.
In the package specification I declared one variable l_emp_name varchar2(100); which I am using in the package body in various procedures.
In first procedure launch_workflow() I assign a value to that variable.
e.g.…
sanket katariya
- 5
- 7