Questions tagged as 'plsql'

Tagged questions
2
answers

Using "If" inside triggers

I have created a trigger to collect an entered value, relate it to another table and change it. That value can be quite peculiar, so I look for it in two fields and also concatenating it: create or replace TRIGGER "INTER_AGENTE" BEFORE INSERT...
asked by 11.05.2016 / 14:19
1
answer

IF nested PL / SQL

Good Morning People; I ask for the collaboration of the community because I can not explain why the second if it is nested is not being evaluated, is not being evaluated and enters if the structure is true or false example (1 = 2) and enters? .....
asked by 23.03.2016 / 14:30
1
answer

traverse 12 csv files with UTL_FILE

Friends, this is the code I'm doing to go through 12 CSV files, but you're only reading the last file, you can help me PROCEDURE SP_CARGA_POLY_EXTERNA (V_ERROR OUT VARCHAR2, V_MENSAJE_ERROR OUT VARCHAR2) IS V_SECUENCIA NUMBER :=1;...
asked by 31.10.2018 / 22:16
0
answers

Backup in oracle db using triggers

I have 2 identical tables, just change the name table1 and table2 , when you enter 3 records in table1 the information in this table must be copied to table 2 and table 1 must be empty again.    The solution must be reached using tri...
asked by 25.07.2018 / 22:09
2
answers

Problem with LOOP PL / SQL, Oracle [closed]

I am currently working on a query with PL / SQL which I have not been able to do, the idea of this query is to be able to traverse (or compare) the rows of a table given the upper and lower limits of the table, that is, for example: there is a t...
asked by 09.08.2018 / 17:54
0
answers

How to make a stored procedure so that I can throw all the data of users who have roles and those who do not have assigned roles

please can someone help me with the following problem, the procedure I have only throws me the names of users who only have roles, but I want to throw all users who have roles and those who do not have assigned roles. these are the 3 tables...
asked by 22.05.2018 / 18:25
0
answers

error when creating a stored procedure

Dear good evening. I wanted to ask for your help, I'm trying to create a stored procedure but it gives me the following error:    Error (17,1): PLS-00103: Encountered the symbol "CREATE" I leave the code (corrected): CREATE OR RE...
asked by 08.05.2018 / 03:15
0
answers

Error with trigger with IF and UPDATE in ORACLE

executing this trigger in ORACLE I got the following error: Table,View Or Sequence reference 'OCEX_COMI.FECHA_ASIG_GT' not allowed in this context. This is my trigger: create or replace trigger ocex_comi_total before insert or update...
asked by 29.06.2018 / 02:46
1
answer

XML - PL / SQL How to get the subnodes of the nodes

I am trying to generate a dynamic insert by taking an XML file but I can not extract the merchandise attributes for another string. So far I was able to extract the first 4 You have to follow this structure The statement is as follows:...
asked by 04.09.2017 / 17:33
1
answer

I am implementing this query correctly with PHP? [closed]

Am I implementing this query correctly with PHP? I have already reviewed the connection data and they are correct, I propose my query based on the official documentation of PHP, however I do not obtain the expected result, in advance I thank...
asked by 19.12.2016 / 18:11