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
PLS-00103: Encountered the symbol "IS" when expecting one of the following: := . ( @ % ; not null range default character
I am facing this error:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/11 PLS-00103: Encountered the symbol "IS" when expecting one of the
following:
:= . ( @ % ; not null range…
Mithun Krishna
- 1
- 4
0
votes
2 answers
dbms_output.put_line() is getting commented and not printing anything in the output except "PL/SQL procedure successfully completed"
When I am using dbms_output.put_line() in any of of Pl/SQL program, this line is not getting printed and it is not showing any kind of error message, whenever I am running my program is is just printing "PL/SQL procedure successfully completed".
For…
FaizanNehal
- 22
- 5
0
votes
1 answer
How to print cursor records?
I have tried to print cursor records, but I can't. Below code, I have tried.
DECLARE
CURSOR CUR_EMP IS
SELECT *
FROM EMP
WHERE Deptno = &DNO;
V_REC CUR_EMP%ROWTYPE;
BEGIN
OPEN CUR_EMP;
LOOP
FETCH CUR_EMP…
Neha pandey
- 3
- 2
0
votes
1 answer
PL/SQL Oracle Package error when executing functions
The package compiles well, but when executing the functions, it gives the following error "'SEARCH FOR_EMP_NO' is not a procedure or has not been defined" what is the problem? I think I am committing some problem with the ver_emple procedure. I have…
BOWIEKNIFE
- 11
- 2
0
votes
0 answers
Need help to find out the root cause of SQL Injection in PL sql package
We have some packages in PL SQL and we did some security scan by Veracode. We have some to solve some SQL injection problem. I am attaching the code and the line number from where it shows the error. We would like to know the root cause and proposed…
Dips
- 11
- 2
0
votes
0 answers
ORA-01722 invalid number despite not casting anything to number
I am figuring out PL/SQL for the first time for a school project, and I have to write a package with a boolean function which takes a user id and a password, and checks if that user has that password. Here is the relevant part of the package…
Abraham Murciano Benzadon
- 1,424
- 13
- 27
0
votes
0 answers
How to debug package body and triggers in Oracle using toad or some other editor
How to debug package body and triggers in Oracle using toad or some other editor. Mainly I am using toad and SQL developer.
When I open package then it shows debug option disable in toad.
vijay
- 33
- 7
0
votes
1 answer
Calling or using oracle array package in oracle apex
I want to calling oracle array package in oracle apex page process.
My package "CREATE OR REPLACE PACKAGE SBPA.DPG_SBPA_ITEM_SUB_CAT AS
/..........................................................................
Program Purpose :…
Md Morshed Alam
- 41
- 2
- 8
0
votes
2 answers
Warning: Package Body created with compilation errors...in plsql
Error:
Warning: Package Body created with compilation errors.
BEGIN
*
ERROR at line 1:
ORA-04063: package body "P12284.EMP_DESIGNATION" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"P12284.EMP_DESIGNATION"
ORA-06512: at…
HARINAVEENKUMAR T
- 11
- 5
0
votes
1 answer
How to pass date object to PL-SQL as the first and only input parameter
First I will be taking a date value as a input variable from the database. Date format is coming in the format as (2020-08-31).
I need to convert this date and pass it into the PL-SQL block in the format as…
Suresh Madhusanka Rodrigo
- 131
- 1
- 11
0
votes
1 answer
What is the right PL/SQL for updating rows without a need to reinsert it?
I new at using PL/SQL and I want the following:
I have this table on Oracle SQLcl
create table Child (
id varchar not null,
name varchar not null,
gender varchar not null,
YearOfBirth number(4) not null,
YearsOfAge number(4) null,
CONSTRAINT Pk…
Aki
- 33
- 6
0
votes
3 answers
Oracle - Insert into tables using dynamic queries
I'm trying to create a dynamic query to safely select values from one table and insert them into another table using this_date as a parameter.
Because this will be called from outside the app, I should be using bind variables.
table1 is owned by…
Sometowngeek
- 597
- 1
- 6
- 27
0
votes
2 answers
If we have out parameter in plsql procedure and return in function.Then why we use procedure instead of function?
If we have only Out parameter in our PLSQL procedure.Then can we use function instead of procedure as function is also able to return the value.
And if we still using procedure then we use this instead of function.
I hope I am able to convey the…
Mogit
- 7
- 1
0
votes
2 answers
Optional parameters in cursor where clause
I have the following sample query which takes values from procedure parameters. The parameter can be either passed or default to null.
SELECT * FROM table
WHERE( table_term_code = '201931'
OR (table_term_code = '201931'…
arsha
- 67
- 6
0
votes
0 answers
Automation of Cart functionality in SQLDeveloper
I have a question that you guys may have an answer to. At our project we have to test our functionality with different types of data (in this case, converted data) and to do that, we produce test data (anonymized production data) where we simulate a…
