Stack Overflow
Stack Overflow

Questions tagged [plsql-package]

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.

240 questions
0
votes
1 answer

How to write a PL/SQL procedure with x input parameters and input/ouput of x parameters combined

I have to make a procedure that will create me autonomously a STUDENT_ID with the input parameters as Name, Surname, Gender, Date_Birth, State. Example : Name: John Surname: Smith Gender: M Birth Date: 17/05/1996 state:…
Silent Storm
  • 21
  • 1
  • 3
0
votes
2 answers

Oracle PL/SQL package version control

We are building an automation process which needs to be version controlled so we can rerun it with certain parameters potentially even years later. We have been discussing ways to achieve a level of "version control". We would like to keep the…
Kinga
  • 9
  • 4
0
votes
2 answers

Get values from XML using SQL

I am new to SQL and I was wondering how to get the values '123189', 'OK' and 'OK' from XML down below? I was using the SELECT from down below but the parameters (nMaxRate,vMaxRateValid and vMaxRateVariation) stay empty when I call this…
OmarLittle
  • 423
  • 1
  • 9
  • 18
0
votes
1 answer

Error PLS-00306: wrong number or types of arguments in call to 'P_CHECKAVGRATE' PL/SQL: Statement ignored

I just started with SQL/PLSQL and I am writing a procedure that gets data from a SOAP api. The SOAP is working fine (tested it via soapUI), the procedure was compiled succesfully, but when I try to call it I have the following error: [Error]…
OmarLittle
  • 423
  • 1
  • 9
  • 18
0
votes
1 answer

How to create an Oracle package with private procedure?

I'm creating an Oracle package and I wonder if it's possible to make a prcedure private, here is my sample code: CREATE OR REPLACE PACKAGE MYSCHEMA.MyPackage AS PROCEDURE MyProcedureA(outputParam OUT VARCHAR2); PROCEDURE MyProcedureB(inputParam IN…
Wadjey
  • 145
  • 13
0
votes
1 answer

convert excel file row to column in PLSQL

I have excel file with this format as shown in the Image. and I want to import it in my Oracle Database in column format , I'm using APEX Platform as well. All the data is in row format and this is just a sample , because this file has maybe 20…
BODYBOND
  • 117
  • 1
  • 4
  • 12
0
votes
2 answers

Pl/Sql Script for update more than 1 000 000 rows

I have a table: id| name | organisation_name|flag |priority|salary 1 | Mark | organisation 1 |null |1 |100.00 2 | Inna | organisation 1 |null |2 |400.00 3 | Marry| organisation 1 |null |3 |500.00 4 | null | organisation 1…
Michael
  • 73
  • 7
0
votes
1 answer

Why the output is printing twice while executing loop in plsql?

set serveroutput on; Declare d_name varchar(25); cursor dep_cur is select distinct department_name from department; BEGIN dbms_output.put_line('Department Names are :'); open dep_cur; LOOP fetch dep_cur …
Ishmeet Kaur
  • 13
  • 4
0
votes
1 answer

report error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small APEX

I got this error report error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small on Oracle Apex v 20.2 When trying to parse data from .xlsx file to a report window when I increased the number of columns more than 85…
BODYBOND
  • 117
  • 1
  • 4
  • 12
0
votes
0 answers

how to use refcursor?

I am trying to run an explain plan using a wrapper, but getting compilation error. Can you please help troubleshoot this error. set serveroutput on var my_cur refcursor; begin :my_cur:=sys.run_xplan('select * from hcc.Tab_A'); …
user1689992
  • 21
  • 1
  • 5
0
votes
1 answer

Find Values Between last 2 special Characters

There's a reference field that concatenates multiple different columns. I'm looking to extract the values between the last caret and the = special characters. There's no fixed length between these values so it could range between 2 characters and…
PAPERCLIPSANDPAPER
  • 77
  • 1
  • 1
  • 10
0
votes
2 answers

How to return null in OUT SYS_REFCURSOR

I have a procedure in the package which returns a SYS_REFCURSOR, i want to return null or empty based on a condition, not sure how can i do it. PROCEDURE test( id_number IN VARCHAR2, resultIN OUT SYS_REFCURSOR) AS BEGIN …
Steve Lennon
  • 69
  • 1
  • 12
0
votes
1 answer

Updating an Excel Cell Using PLSQL

Is there a way we can update an existing Excel file using only PLSQL codes? I saw a working PLSQL code that can create an excel file and write a text into a cell I specified, as well as a PLSQL code that can read an existing excel file and return…
Karlo Imbat
  • 1
0
votes
1 answer

PL/SQL UTL_FILE: How the loop automatically returns the next line?

This is PL/SQL code I am using for working with UTL_FILE package: DECLARE vfile utl_file.file_type; vfloc VARCHAR2(100) := 'UTL_TST_DIRC'; vline VARCHAR(32676); BEGIN vfile := utl_file.fopen(vfloc, 'test.txt', 'r', 32767); …
Dev Anand
  • 314
  • 1
  • 14
0
votes
1 answer

Does INVOKERS rights mean the DB session initiator or the user calling the Procedure

We have an application running on Oracle APEX (ORDS) workspace with parsing schema as "SCHEMA_A" I have a package "PKG_A1" in schema "SCHEMA_A". I have a package "PKG_B1" in schema "SCHEMA_B". I have another package "PKG_B2" in schema "SCHEMA_B" and…
Toufiq - Oracle APEX
  • 143
  • 3
  • 14
1 2 3
…
15 16