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
0 answers
Can someone assist with these plsql question, i'm having a hard time of understanding it fully
**1. Create a procedure called InsertProduct that takes in all the details for a Product and inserts it into the Product Table.
What i attempted:
CREATE OR REPLACE PROCEDURE InsertProduct
(a IN varchar2,b IN varchar2,c IN int,d IN real)…
britt
- 1
- 1
0
votes
1 answer
PLSQL Exception handling in GET_FILE
Trying to handle exception if the input file received has invalid records or no data. The below exception runs in loop even though the input file has only 1 record.
LOOP
BEGIN
UTL_FILE.GET_LINE(a_UIN_input_file,a_UIN_file);
…
arsha
- 67
- 6
0
votes
2 answers
Need to convert any timezone to GMT time zone in oracle
Query condition is like below:
creation_date >=last_success_run_date
here creation date is coming like sometime PDT(Pacific Daylight Time) or sometime PST (Pacific Standard Time) format.
and last_success_run_date is always GMT format.
So, I want to…
nodev_101
- 99
- 10
0
votes
1 answer
PL/SQL Oracle :- Dynamically UNPIVOT ORACLE TABLE on passing a value
I have a table as below with data:-
Item COL1 COL2 COL3 COL4 COL5 COL6 .... COL 30
A 1 1 2 3 4 2 5 2
B 2 6 4 3 5 2 5 1
C 3 …
user12090504
- 1
- 1
0
votes
4 answers
How do I store values from a single column into a single variable in oracle?
The below is my code:
SELECT
/*+ parallel (sales 8) */
COUNT(1)
INTO v_datacount_actualtable
FROM sales
WHERE processingunitseq=38
AND (compensationdate BETWEEN TO_DATE(v_startdate,'DD-MON-YYYY') AND…
Divya Sam
- 131
- 2
- 10
0
votes
2 answers
Read XML document with PL/SQL, XML tag are not fixed
Need to read XML document and get the values of element tag and their values. but until run-time the values of the XML element nodes are unknown. so can't use XPATH to extract values. Any suggestions to handle this problem
assume this is the xml…
Osura Weerasinghe
- 73
- 7
0
votes
1 answer
How to get information about all types of data declared in a given package
Using the information from the representations of the data dictionary, get information about all types of data declared in a given package.
NAME | TYPE | …
Maxim Kuznetsov
- 11
- 3
0
votes
1 answer
issues with package syntax
i am trying to create a package called MSGG_SESSION with a procedure authenticate that accepts two VARCHAR2 parameters for username and password. i am suppose to put an package-private NUMBER variable for the current person ID.If "authenticate"…
0
votes
2 answers
Dynamic Cursor with parameterised schema name and using for BULK INSERT in target table
I have source_table in different 22 schemas and need procedure to create for bulk collect and insert into same target table in oracle stored procedure.
I'm trying and not getting records inserted getting error ORA-00911: invalid character but there…
Radhesh
- 3
- 2
0
votes
1 answer
how to use dbms_lob.substr in sql*plus
Given a table:
desc SOL_3_ARTIFACTS
Name Null Type
---- ---- -------------
DATA BLOB
ID VARCHAR2(100)
If I need to read content of a BLOB column as VARCHR2 with SQL*plus, I'd need a statement like this:
select…
techie11
- 1,243
- 15
- 30
0
votes
2 answers
C# with plsql in Visual Studio 2010
How to write the crud application with plsql package?
Logic should be implemented using plsql function and procedures and bundled as Oracle package.
0
votes
2 answers
i have a issue in body package pl/sql when I select
I currently have a procedure stored inside a package. I want to get all the data from the client table but I have an error. the problem is in procedure stored p_listar_cliente.
the code is:
create tables and insert
create table cliente (id NUMBER,…
Jhon Alexander Jimenez Morales
- 127
- 1
- 1
- 7
0
votes
1 answer
How can I call a procedure in a different package in a different schema from another
I want to call a procedure declared in one schema in one package different from the currently running schema and package
There is another question almost related, but my difference is that the called procedure is in another schema and package, not…
Woodsman
- 901
- 21
- 61
0
votes
1 answer
How to add SRW package to existing Oracle Database?
I'm setting new oracle db and want to add SRW package which is used for oracle reports.How to add this package and where can I found the functions and procedures of this package? Or should I write PL/SQL codes myself ?
Edit:DB is used for ERP.
user11567043
0
votes
0 answers
To create PL/SQL package with 2 procedure to create dynamic db_link based on parameters flag 0,1,2 and insert, update existing tables
.procedure to create and drop dblink( flag)
if passing 0 then create
if passing 1 then check
if passing 2 then drop
execute immediate 'create database link DBLINK_' || cur.SYSTEM_NAME ||
' connect to BOOWNER identified…
Umair Khan
- 21
- 3