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
ORA-00942: table or view does not exist in Package based Procedure
I have gone through similar threads but unable to understand the root cause of the error.
I have an Oracle Schema as "PRP".
PRP has one table Named : "MY_TABLE".
PRP has one package Named : "My_PKG" with authid current_user
Package contains…
Prathamesh Pitale
- 23
- 1
- 8
0
votes
1 answer
PLSQL Proc to run sql script and save output to windows directory in excel or csv format
I have requirement to run custom oracle sql script and save output as csv/excel to windows directory where we have pl/sql is installed .
script has around 30 columns .for sample below query can be used
SELECT emp_idno,emp_fname,emp_lname,emp_dept…
Sri
- 15
- 2
0
votes
1 answer
Oracle PL/SQL Scalar Variable Size Syntax Ambiguity
What types of expressions are allowed for declaring a scalar variable's size in a PL/SQL package?
Here is a db<>fiddle showing size expressions other than numeric literals where some produce errors and others don't. Below is a snippet.
create or…
Alex Bartsmon
- 471
- 4
- 9
0
votes
1 answer
Multiple functions calling a same function. I need to create a flag
Multiple functions calling a same function. I need to create a flag.
Suppose I have 4 functions(f1,f2,f3 and f4) in a PLSQL package.
F1 is being called by F2,F3 and F4. All I want a flag in order to track which function call the F1.
For example . If…
prashant chhetri
- 91
- 1
- 8
0
votes
1 answer
oracle package and trigger
Create a database that contains four tables department, employee,
address and contact info, then Store 5 Records in each table.
Write the PL/SQL Statement for the following:
Store a record into employee, address and contact using trigger.
Retrieve…
The Tech Guy
- 1
- 3
0
votes
1 answer
[PL/SQL]how to make a loop that runs multiple procedures
suppose I have a list of procedures p1,p2,p3..pn , each procedure has only one output number parameter, basically each procedure is a constant number. How could I create a loop that runs all these procedures and the results are displayed on the…
Giovanni5454
- 33
- 1
- 6
0
votes
0 answers
How to reset the sequence inside procedure oracle
I have created one procedure, inside that i have sequence too, here when i am calling the procedure some insert will table in table..
But if i call the procedure again and again it should delete the records and insert again the current records…
Abinnaya
- 203
- 4
- 26
0
votes
0 answers
ORA-06502: PL/SQL: numeric or value error: character to number conversion error in package function
I am trying to create a function that returns pipelined table with input parameters being varchar2, date or number. I am trying to input amount as varchar2 because I can't process it like a number with comma before decimals. Here is body of my…
GodDamnLawyer
- 67
- 10
0
votes
1 answer
How to extract data stored in LONG column (datatype) using PL/SQL?
I am working on a project and In which there is a landing table where a long msg comes in the table continuously and Table has two column one ID and MSGTEXT(Long msg is stored in this column). That long msg have a lot of data from which I have to…
Aanchal shrivastava
- 11
- 3
0
votes
0 answers
How to split string into rows based on condition in plsql
i have a comma separated string as below
M1: TestString1, M2: TestString2, M3: TestString3, M4: TestString4, M5: TestString5, M6: TestString6, M7: TestString7
i need output…
Pasha Md
- 37
- 5
0
votes
0 answers
How to filter the data using below given code
Below given code will give all data from all the tables present in HR user and i want to use the same code to filter the data from all the tables by using ID columns.Can i do that with same code?
EXEC to_check_data('employees');
EXEC…
Aman
- 19
- 3
0
votes
2 answers
how to convert row as column in sql query
how to convert row as column in sql query, below is my query..
SELECT sum(result_value), element_name
FROM pay_assignment_actions paa,pay_payroll_actions ppa,per_time_periods ptp,pay_run_results prr,
pay_element_types_f…
Abinnaya
- 203
- 4
- 26
0
votes
1 answer
Error ORA-00904 while calling procedure inside package using EXECUTE IMMEDIATE
I'm working on a PLSQL package that calls another PLSQL package that returns separated results (i.e OUT variables) as follows:
(1) SYS_REFCURSOR
(1) NUMBER
(1) VARCHAR2
This is the dbfiddle I build.
Full code of the linked dbfiddle:
/* Main table…
Marco Aurelio Fernandez Reyes
- 2,071
- 2
- 9
- 33
0
votes
2 answers
Read data from a text file and pass that data in a stored procedure input parameter using pl/sql scripts only
I have a text file 'C:\file\Datafile.txt' which contains the below data.
1,Dixon,200
2,Sam,400
3,Peter,200
now I have a SP in oracle which accepts three input parameters (employeeid, employeename, salary).
I want to pass the values in that text…
Vlogs Bengali
- 85
- 1
- 13
0
votes
2 answers
Pass PL-SQL variable value to JavaScript function on PL-SQL Procedure
I have an application on Oracle Apex 20.2 with oracle DB 18c.
and I have a pl-sql procedure that render questions and some specific actions.
now I want to enhance the actions using JavaScript functions but my problem is :
For example I have this…
BODYBOND
- 117
- 1
- 4
- 12