Questions tagged as 'pl-sql'

Tagged questions
0
answers

List only the largest age group?

I'm trying to make a comparison by age to list only the age corresponding to your age range. Ex: 20 year age range from 0 to 43. SELECT DISTINCT U.USS_CODIGO, t.con_codigo, t.CON_SEQUENCIA, t.PLA_NUMERO, t...
asked by 07.06.2016 / 19:07
0
answers

ORA-00922 error in table creation in apex 5

I'm trying to create a table in apex5 with reference, having a foreign key from another table and having that foreign key column be populated. But creating is returning the error:    ORA-00922: missing or invalid option I've already check...
asked by 26.02.2016 / 18:27
1
answer

XML Data Format NFe

I'm trying to insert a date into an Oracle PL-SQL table. I look for the date when reading the XML of an NFe, however the tag appears like this <dhEmi>2015-10-02T14:49:52-04:00</dhEmi> I did some searches on the internet and...
asked by 28.10.2015 / 20:12
1
answer

How to execute procedures inside another? [duplicate]

I have this procedure where I save within a cursor all the other procedures that need to be executed, then I scroll the cursor putting the procedure names inside a variable. How do you execute these procedures that have the name inside the...
asked by 10.07.2015 / 18:43
1
answer

Execute Immediate with line breaks getting Invalid Package

I'm creating a package dynamically ie: DECLARE vpackageletras VARCHAR2(2000); vvalorpossuia VARCHAR2(10); vvalorpossuib VARCHAR2(10); BEGIN IF letras.possuia THEN vvalorpossuia := 'TRUE'; ELSE vvalorpossuia := 'FALSE';...
asked by 21.10.2014 / 22:51
1
answer

XML import for Oracle tables

. Hello, I need to import an XML file into an oracle table. There are several examples on the internet, but none of them worked for me. In general, I'm having the error: LPX-00210: expected '<' instead of '�' ORA-06512: at "SYSTEM.LOAD_XM...
asked by 30.06.2014 / 00:32
1
answer

PLSQL - Query between tables

Hello, I would like suggestions on how I can perform a query between two tables (Person_Personal and Person), where we have the Person (id_id, name) table, the Permissions table (id_add, description) and the Person_Permission table (person_id per...
asked by 30.11.2018 / 12:24
1
answer

How to identify and correct error 00302 in Oracle? [closed]

How can I correct an error of this nature (ERROR 00302) and how to know the line in which the error is in Oracle SQL Developer? Error(16,6): PL/SQL: Statement ignored Error(16,52): PLS-00302: component 'NOME_PESSOA' must be declared Error(17,6...
asked by 19.07.2016 / 20:23
1
answer

CONDITION WITHIN WHERE CLAUSE

Good afternoon!   I have a task to perform a select, but the parameters are passed as variables and I need to treat the input of one of these variables with the following logic: if & CT is not null, then I add in the condition of select the...
asked by 20.09.2018 / 18:55
1
answer

PLSQL - Procedure to Encrypt Password

I searched the internet for a procedure to encrypt users password , however I only found functions . Is there a way to generate a procedure to perform this process? CREATE OR REPLACE FUNCTION MD5(VALOR VARCHAR) RETURN VARCHAR2 IS...
asked by 27.09.2018 / 02:59