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
1
vote
2 answers
Is it OK to drop Invalid Objects that have a Referenced_Owner/Referenced_Name? (dba_dependencies)
I tried to clean out my Oracle 18c databases of Invalid Objects. I was given the go ahead from the developers to remove a few invalid objects but after googling, I noticed that I would have to watch out for other dependent objects.
If I drop these…
Chubs
- 11
- 3
1
vote
1 answer
How can I write a plsql code for creating a new split partition in a table?
This is my alter statement:
alter table demo_table
split partition PART_35 values('9999') into (partition PART_35, partition PART_36)
The table already consists of a list partition on emp_id,where PART_35 is the last partition created and it is…
Saikat Banerjee
- 11
- 1
1
vote
1 answer
ORA-29259 end-of-input reached calling utl_http.get_response PL/SQL
I am trying to call to a web service using the Oracle UTL_HTTP package. The call is for HTTPS Post and include utl_http.set_wallet.
when the DB try to execute a
req utl_http.req;
res utl_http.resp;
res := utl_http.get_response (req);
we get the…
Rotem87
- 105
- 1
- 17
1
vote
1 answer
I tried to fetch bulkcollect records from sys_refcursor and tried to insert another table using forall but it throw an error message
--My first procedure
CREATE OR REPLACE PROCEDURE P1(V_SALARY NUMBER,OUTPUT_VALUE OUT SYS_REFCURSOR)
AS
BEGIN
OPEN OUTPUT_VALUE FOR
SELECT FIRST_NAME,LAST_NAME
FROM EMPLOYEES
WHERE SALARY >V_SALARY;
END;
--Second procedure
CREATE OR…
vinoth kumar
- 9
- 5
1
vote
2 answers
ORA-00600: internal error code when compiling function returning Pipelined
I have a package specification with code like below
CURSOR my_cur IS
select ...;
TYPE mytype IS TABLE OF my_cur%ROWTYPE;
FUNCTION myfun
RETURN mytype PIPELINED;
when I try to compile the package specificaiton, I get the…
Coding Duchess
- 6,445
- 20
- 113
- 209
1
vote
1 answer
What is the difference between a "procedure name IS' and a "Procedure name AS" in Oracle?
PROCEDURE sample (p_num1 IN TABLE%TYPE,
p_num2 OUT NUMBER) IS
OR
PROCEDURE sample (p_num1 IN TABLE%TYPE,
p_num2 OUT NUMBER) AS
E. Martinez
- 13
- 2
1
vote
0 answers
WAP in pl/sql to create package name calculator that contains functions for basic mathematical operations
getting an error
SQL> select calculator.add(10,10) from dual;
select calculator.add(10,10) from dual
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 24…
Vishal Kumar
- 21
- 5
1
vote
1 answer
Can you use a PL-SQL procedure in JavaScript in a PL-SQL package?
I want to create a button using JavaScript/ Apex, so that when I click on it, a PL-SQL procedure is being "called". Similar to a regular html button, but the onClick="JavaScript function()" will be a pl-sql procedure instead. I'm trying to do this…
a i
- 11
- 2
1
vote
2 answers
ORA-21780: Maximum number of object durations exceeded
There are 20 tables (table_id from 1 to 20) whose count needs to be taken and updated in DATA_COUNT.REC_CNT_ACTUAL(tablename.coumnname).
For 13 tables the count update is successful. Then this error pops up.
Initially I wrote the below as a…
Divya Sam
- 131
- 2
- 10
1
vote
0 answers
how to convert php code into oracle package for delete SQL using associative array
I have php code which does a delete where on tables. problem is these tables are becoming very large and running the delete statements in oracle will be so much faster.
here is my php code which i want to turn into oracle package
public function…
shorif2000
- 2,582
- 12
- 65
- 137
1
vote
0 answers
Uncompress / process big file gz stored in Oracle folder
Uncompress big file in Oracle 11
Hi Guys,
I have one big (around 4gb) zipped file (gz) stored in an Oracle folder. The file contains some data that have to be uploaded in a table. The unzipped file is around 50gb.
I cannot use the preprocessor…
Elfo Scuro
- 53
- 5
1
vote
1 answer
PRAGMA AUTONOMOUS_TRANSACTION
I have procedure A with PRAGMA AUTONOMOUS_TRANSACTION to log the activity of a main program.
Now I am calling this program A in a procedure B to log the activity process in program B. If any error occurs in program A it fails the program B also. How…
Vikas
- 107
- 7
1
vote
2 answers
My code takes too much time for execution is there any efficient way to do this
Here there is 3 table
1.employee(eid,ename),
2.address(aid,address),
3.employee_add(eid,aid)
employee and address has many to many relation in it.what I need to do is to clean the duplicate from address table without any data loss from employee_add…
user11000599
1
vote
2 answers
PL/SQL: could not find program unit being called when calling packages
I am recently facing issue "Program Unit being called" when calling another package/procedure with in our package.
Whenever we change anything in the child or parent package and execute the parent package it shows the error "Could not find program…
Venkatesh
- 11
- 4
1
vote
0 answers
ORA-22288: file or LOB operation FILEOPEN failed even if document can be accessed
I am trying to open a XLSX file using Anton Scheffer's package (here). I have my path object created, rights etc. And still get error below when I run my query. Tried lots of methods and i couldn't find a way to fix this . Please, any idea can…
Adi
- 311
- 4
- 19