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
-1
votes
4 answers

Assign a value to a variable on RETURN PL/SQPL

Is there a way to achieve this in PL/SQL oracle ? RETURN (return_status:=1); It gives a compilation error when I try to do this. If this is not possible please suggest a better alternative instead of doing return_status := 1; RETURN…
M. Haris Azfar
  • 598
  • 6
  • 16
-1
votes
1 answer

Pl/sql function and procedure

We need to INSERT or UPDATE data of table consultant_skill , create needed functions, procedures … that accepts consultant id, skill id, and certification status for the task. The procedure should be user friendly enough to handle all possible…
user10997164
  • 35
  • 1
  • 6
-1
votes
1 answer

Getting PLS-00103: Encountered the symbol "/" error in creating packages

Getting error Error(8,1): PLS-00103: Encountered the symbol "/" Tried inserting / symbol at the end of package definition gives error -Error(9,1): PLS-00103: Encountered the symbol "CREATE" What I want is to do validation in CreateShipment and…
rahul bhandari
  • 1
  • 5
-1
votes
1 answer

PL/SQL INSERT INTO & Partitions

I would like to start with saying that I am still learning PL/SQL. I was wondering if you could share your opinion on the following topic/questions. Basically, I want to insert data from Table X into Table Y via a package. I have already read about…
VBABegginer
  • 91
  • 1
  • 1
  • 7
-1
votes
1 answer

I want to insert one billion records in the oracle database

I have to insert one billion record in oracle database table. I have 2 column . One column is a seqence number which follows till 1,000,000,000 Second column is a varchar2 field ... and it is in the format of abc~122~373~7777777~5367 . That is first…
Chirag Karnawat
  • 13
  • 3
-2
votes
0 answers

PL/SQL Table TYPE issue in r12.2.10

I have a requirement to process and create/update the incomming PO Requisitions header, lines and distributions in Oracle EBS R12.2.10. There is a standard out of the box PO Requisition web service available but that comes with 3 seperate end points…
Arshad
  • 7
  • 3
-2
votes
1 answer

How to write a procedure using cursors to insert multiple rows in a table using condition?

i'm trying to write a procedure to insert multiple rows in a table using cursors. for example, i have multiple deals numbers DosNum (D1,D2,D3,D4) for each deals we have DosID (001,002,003,004) in a table folder i want to get all these DosID then…
Ahmed B.Kahla
  • 1
  • 1
-2
votes
1 answer

create a package in Oracle PL/SQL for some frequently used code

during development, there are many codes/SQLs can be re-used, which is used to implement some kind of business logical. To avoid re-inventing the wheel, I propose to create a package, which contains these code/SQL/functions; then, any new code can…
fred wu
  • 55
  • 6
-2
votes
2 answers

why am i getting this error. Can anyone help me?

The following Oracle statement: CREATE OR REPLACE PACKAGE BODY pk1 IS FUNCTION RETURN_BOOLEAN(v_accno bank.accno%TYPE) RETURN BOOLEAN IS BEGIN SELECT COUNT(*) INTO v_count FROM bank WHERE…
Vatsal Panchal
  • 1
-2
votes
1 answer

How to get multiple rows in Case Then clause

I want to write the case expression for this condition in View Indicate "Y" in the report if Livestream (all) is selected and display all the individual platforms under livestream (App, Online,O&O,etc). If Livestream (all) is not selected, but…
ARH
  • 25
  • 3
-2
votes
1 answer

search in text using subtext in Oracle PLSQL

I have this query in master_t table that hold ration_category column and many number of sectors in sectors column like this 'BN:INS' or 'BN' or 'BN:IM:INS' etc.. select distinct ratio_category d from master_t where status = 'Y' and (SECTORS =…
BODYBOND
  • 117
  • 1
  • 4
  • 12
-2
votes
1 answer

Creating a package

I am trying to Create a package MSGG_SESSION with a procedure authenticate that accepts two VARCHAR2 parameters for username and password. Put an package-private NUMBER variable for the current person ID. If “authenticate” matches a username and…
ndubizuacn
  • 1
-3
votes
1 answer

My pl sql block is executing for only 15 min i need to increase the execution time in toad

I need to increase PL/SQL Block execution time more than 15 min in toad. Is there any settings in toad means suggest me ?
Ramesh T
  • 1
  • 1
-5
votes
0 answers

Converting oracle package into postgres compatible

We are in the process of migrating some of our services from Oracle to PostgreSQL. As part of this migration, we have a requirement to convert a few Oracle packages to be compatible with PostgreSQL. We need advice on how to begin. Are there tools…
vigneshwar reddy
  • 145
  • 10
1 2 3
…
15
16