Questions tagged as 'plsql'

Tagged questions
1
answer

Error ORA-06531: Reference to uninitialized collection

They could help me know what the problem with my program is ... I have this code inside a package: TYPE t_rec IS RECORD(t_id INTEGER,t_text VARCHAR2(40)); TYPE t_recs IS TABLE OF t_rec; FUNCTION test_func RETURN tp_recs PIPELINED AS currec t...
asked by 12.04.2017 / 19:33
1
answer

on a pl / sql exercise

CREATE OR REPLACE PROCEDURE orden (n1 IN OUT number, n2 IN OUT number, n3 IN OUT number) AS menor number; mediano number; mayor number; BEGIN IF n1 < n2 THEN IF n2 < n3 THEN mediano := n2; may...
asked by 16.04.2017 / 12:25
1
answer

Store Select procedure in Oracle can not find data

I have the following code in Oracle: CREATE OR REPLACE PROCEDURE STOREDSUBMODULOS(IDCATMODULO IN NUMBER , IDCATSUBMODULO OUT NUMBER , CLAVESUBMODULO OUT VARCHAR2 , DESCRIP OUT VARCHAR2) AS BEGIN SELECT ID_CAT_SUBMODULO , CLAV...
asked by 10.03.2017 / 19:07
0
answers

Temporary table SQL SERVER to CURSOR in PL-SQL

Greetings How could you transform the use of a temporary table to make an update in SQL server to an equivalent code in PLSQL with a cursor? ALTER proc [dbo].[sp_lista] (@pcFI datetime, @pcFF datetime, @vSuma tinyint) as beg...
asked by 21.02.2017 / 18:47
1
answer

Cursor with Update

Greetings from Costa Rica, I'm starting with Oracle PL / SQL (running the systems race) and I want to build a cursor as a practice to update the registry of names, emails, telephones and cards of the entire database. The information of cli...
asked by 09.12.2016 / 00:27
1
answer

How can I change the structure of a column in oracle report builder

Good morning, I am currently managing oracle report builder 11g for the modification of a report, the report is created by means of a PL / SQL query but due to some changes there was a "Total" column with a structure number (9.2) and I had to...
asked by 30.06.2016 / 01:41
2
answers

DBMS_OUTPUT.PUT_LINE does not work with cursors

If I execute this line, it perfectly shows the output of the DBMS BEGIN DBMS_OUTPUT.PUT_LINE('HOLA'); END; but when executing this process DECLARE CURSOR mayor_valor IS SELECT nombre, descripcion FROM producto WH...
asked by 08.05.2016 / 04:42
0
answers

PL SQL problems with 2 subprograms of a package

I have problems when carrying out these two subprograms (in a TRATAR_VENDEDORES package): SELLERS_ AND_ YOUR_DIRECTORS: Procedure that receives the number of a vendor and visualizes its number, name, title, and the same data of its director....
asked by 20.05.2016 / 11:47
1
answer

PL-SQL perform query using null filters or not

Is there any way I can concatenate to a select a query according to a condition? for example in I have a procedure in which I will receive N input parameters, the query I have it ready but since they are filters not all parameters will come with...
asked by 03.03.2018 / 18:24
1
answer

in pl / sql how to count the number of records in a [closed] table

In pl / sql, how to count the number of lines in a table and then get me a message I have x providers in the provider table     
asked by 23.03.2018 / 18:15