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
vote
1 answer

PL/SQL Automatic deletion of data from 20 days ago

I have a query that removes my data in DB from 20 days ago every time I use it. Can you please advise me on how I can automate this task? What would be a better solution? Using procedures or packages? I'm sorry for the beginner questions, I've just…
Forgiven Des
  • 19
  • 4
1
vote
0 answers

Oracle Function Return a Reference for Target of Assignment

Is it possible for an Oracle package (PL/SQL) or object function to return a reference to one of it's attributes, so that in the calling scope an assignment made to that attribute updates the attribute in the object instance or package? Here is a…
Alex Bartsmon
  • 471
  • 4
  • 9
1
vote
3 answers

i'm getting error while running plsql package working till package creation

create table employee( employee_id number(10) NOT NULL, employee_name varchar2(50), employee_sal number(10), employee_role varchar2(50), employee_age number(10), CONSTRAINT employee_pk PRIMARY KEY(employee_id) ); insert into employee(employee_id,…
Ravindra
  • 57
  • 6
1
vote
1 answer

ORA 29260: network error: TNS:connection closed

When i try to connect an sftp location from my oracle machine using a PL/SQL procedure, i got the ORA-29260: network error: TNS:connection closed error. No problem with telnet connection Target sftp machine is added to ACL No problem on file…
Ibrahim Demirtas
  • 11
  • 2
1
vote
1 answer

sonarqube scanner for plsql files stored with .pak extension not scanning

We have stored our PL/SQL files with .sql and .pak (for packages) extensions in bitbucket and we are trying to run sonarqube scanner on these files but the scanner is not taking .pak files into consideration while scanning. the…
Deepak.Pal
  • 35
  • 5
  • 13
1
vote
1 answer

Procedure to insert in unique in values into tables not working

I'm a beginner in this language and i'm being asked to insert via procedure some unique variables into the tables aeropuerto and terminal (the variables have to be unique compared to the rest in the tables) and after thinking, this is as far as i…
Wazabi
  • 83
  • 5
1
vote
0 answers

DBA_OBJECTS vs ALL_OBJECTS

I have created one package in my schema. I am able to see the new package under the all_objects but dba_object is not giving any result. SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME='UT_AIP_FX_AGGREGATED_ORDER_PKG'; -- No row fetched. SELECT * FROM…
Rakesh Raikwar
  • 11
  • 2
1
vote
2 answers

PLS-00215: String length constraints must be in range (1 .. 32767)

I have a oracle package and there is a function in it which is having out parameters. the package name lets say ppp and function name lets say fff. function is below and i am unable to execute the function with out parameters. function- FUNCTION …
TheSacredKiller
  • 121
  • 3
  • 8
1
vote
0 answers

Oracle pl/sql assign variable holding sql text to sys_refcursor and loop through the records

I have below code where function ReturnSysRef returns SYS_REFCURSOR, this function holds the SQL text in a variable and then opens the SYS_REFCURSOR on that variable and returns it. Function MyFunc is a pipelined function which calls ReturnSysRef…
imaginecreate
  • 11
  • 1
1
vote
0 answers

SimpleJdbcCall - How to extract table parameter from stored procedure in package

This is my situation: I am trying to call a procedure (which has been declared within a PL/SQL package) with two parameters: PROCEDURE p_process_docs ( p_cod IN NUMBER, p_doc_t OUT O_DOC_T ) O_DOC_T is defined as following: create or replace…
MangaPowerZero
  • 58
  • 5
1
vote
0 answers

create receipt for IR-ISO process in Oracle apps r12

After internal sales order created, I want to receive that material through backend means to create receipt after delivery number generated. I have tried this: First insert the data into rcv_header_interface,then into rcv_transaction_interface then…
vishalbhartivb
  • 11
  • 1
1
vote
0 answers

how to use DDE.Initiate and with whatsapp desktop

i want to use dde.Initiate to write message in whatsapp desktop but i have this error message ora-106556 declare ConvID PLS_INTEGER; whatsapp varchar2(2000) := 'C:\Users\`enter code here`AMMAR\AppData\Local\WhatsApp\WhatsApp.exe'; …
Ammar Hussien
  • 11
  • 1
1
vote
0 answers

Issue connecting to a vendor server using UTL_HTTP

I am trying to write a PL/SQL procedure that connects to a vendor server and transfer some student data. I have been using UTL_HTTP with no success. Below is my UTL_HTTP cpde. I cut most of the data for easier read. var_data_body…
brown_rice
  • 11
  • 1
1
vote
1 answer

How to write select plSQL script by filtering the value in Partition and then subpartition

I have a table which has Partitions and subpartitions. I have to first filter the results of Partition's High_Value (TO_DATE(' 2020-03-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) with less than some date value and then in the…
Vinay
  • 11
  • 2
1
vote
1 answer

Find a column and a value from a schema scan all the table in oracle

I am trying to find a column (ABC) and it's value 1234 from a schema , basically i need to to check if ABC and a value from this column 1234 is present in any other table that is mapped to ABC , i tried to do a search the most efficient way but it…
Data2explore
  • 452
  • 6
  • 16
1
2
3
…
15 16