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

Oracle procedure inserting multiple rows from result of query

I am attempting to create a procedure that will INSERT multiple rows into a table from the results of a query in the procedure. The setup below works fine but I am having difficulty inserting the employee_id, timeoff_date from the output of the…
Beefstu
  • 804
  • 6
  • 11
0
votes
1 answer

Is there any PL/SQL script to modify column value of each table in each schema of Oracle Database

I have written pl/sql code to modify column values in a table of one schema. But I need to execute the same script in each table of each schema. I will take the list of the table name, column name from spreadsheet. define schema_name = 'D'; define…
Vinod Sirikonda
  • 11
  • 3
0
votes
2 answers

PL/SQL: ORA-01031: insufficient privileges 6/1 PL/SQL: SQL Statement ignored GRANT

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production I'm getting the above message when trying to create a package. I can simulate with a very simple procedure and select statement. My understanding is that have SQL select…
Barry Brierley
  • 27
  • 7
0
votes
1 answer

send http request in toad/pl sql periodically

I am new to PL SQL and currently working on a small procedure ment for logging. The goal of the procedure would be to recive some parameters from where-ever it's called and then to write those parameters in a table. This procedure would also have…
OmarLittle
  • 423
  • 1
  • 9
  • 18
0
votes
1 answer

Compare variable to a value in a query

I have a cursor that I need to loop through and check a couple conditions. If the person's category is greater than 24, I need it to then see if the person also had a previous record in the table and change the value of the v_check variable if it…
user13034980
  • 9
  • 4
0
votes
1 answer

PLS-00382: expression is of wrong type. PL/SQL: Statement ignored

I tried executing a simple package with function overloading. Below is the package code. --package specification: create or replace package over_load as FUNCTION print_it(v_date date) return date; FUNCTION print_it(v_name varchar2) return…
Sasikumar Gunasekaran
  • 5
  • 4
0
votes
1 answer

Get name of nested procedure that called my procedure

I am new to PL SQL and I want to know is there a way (method/function/etc) that I can get the name of nested procedure that called my procedure? For example, I have my_procedure and it gets called by another_procedure nested in another_package. I…
OmarLittle
  • 423
  • 1
  • 9
  • 18
0
votes
1 answer

Commit question in PLSQL and Zend Framework

I would like your point of view about writing Oracle PL/SQL stored procedures and calling them in a Zend framework 3 controller. If in my PL/SQL strored procedure I have a commit at the end of my procedure, and I use it in a controller with in…
Samuel N.
  • 13
  • 5
0
votes
1 answer

PL/SQL Update row value via cursor

I am new to pl/sql and I got stuck. I have a table consisting of 3 columns: package_uid, csms_package_id and flag. First two columns are filled and the third is empty. Flag column is filled when a procedure is called in a way that procedure compares…
OmarLittle
  • 423
  • 1
  • 9
  • 18
0
votes
1 answer

Software AG Designer doesn't ask for Input while running a PLSql Procedure

I am trying to run PLSql procedure in Software AG Designer application, while running it as a service, it doesn't ask for input. The Stored procedure is as follows: CREATE OR REPLACE PROCEDURE getProductDetails(productName VARCHAR, productResult…
Panther Coder
  • 1,058
  • 1
  • 16
  • 43
0
votes
2 answers

PLSQL Error in apex when compiling the following code- PLS-00103

I just referred to similar post related to same ORA & PLS error I faced, but still I can't resolve it using provided solution. I get the following error: PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following: begin…
CloudyL
  • 1
0
votes
1 answer

PL SQL Package with Procedure, PLS-00323: subprogram or cursor

Please help me. I am new to PL SQL. I want to Display On Screen all these details Customer.customerNo, Customer.customerName, Customer.custBalance, customerOrder.orderDate, customerOrder.orderNo from 2 tables [Customer, CustomerOrder]. Using the…
user7657688
  • 11
  • 6
0
votes
3 answers

Exit Loop when first record found

I have a cursor that might return 2 rows for an id . I want to loop through the cursor and exit when the first row for each id is found . Cursor find_c is Select t1.year,t1.sum(charges) charge from table t1 join table t2 on t1.id=t2.id and…
arsha
  • 67
  • 6
0
votes
1 answer

Why do I get an error in calling this procedure?

I have a procedure named student_id procedure student_id ( v_surname in varchar2, v_name in varchar2, v_date_birth in varchar2, v_gender in varchar2, …
Silent Storm
  • 21
  • 1
  • 3
0
votes
2 answers

Boolean return value of some function inside SELECT

I am working on a package in PL/SQL. This is my spec: TYPE outrec IS RECORD( tw_m_id NUMBER, tw_m_dealer_id NUMBER, tw_number NUMBER, check_uid …
user15349320
1 2 3
…
15 16