Questions tagged as 'oracle'

Tagged questions
2
answers

Oracle insert too many values

Personal Good evening I want to insert data in a table but it presents an error "too many values" I will put my code for you to analyze. Insert into account tab (account_id, bank_id, account_id, account_id, account_digit_number, account_type_...
asked by 06.04.2017 / 05:36
1
answer

How to suppress the Oracle input window without using set sets off

I need to insert an image into oracle using php, but after I convert it to insert into the database, it receives some characters & in the middle of the string, this character in Oracle triggers an input screen, when this input screen is fire...
asked by 06.03.2017 / 17:09
1
answer

Why this query does not work in Oracle?

I'm translating a SQL Server query to Oracle and found an error that does not make sense and I'm not getting it fixed. The error displayed is as follows: ORA-00904: "ITM"."NRO_INT_ITEM": identificador inválido 00904. 00000 - "%s: invalid i...
asked by 12.01.2017 / 12:35
3
answers

Update in a field that can not be negative

I need to do a update in a certain field, where it should arrive at least until "zero" can not be negative. And when I get to zero I need it from the update of the remaining amount in the next field. "The setting is for it to drop the first...
asked by 05.01.2017 / 19:29
1
answer

Write to oracle without repeating name

I have this block inside a procedure that records a representative, which comes from a screen in Classic ASP. v_qtd_rep := ts_obtem_dados_no_xml(v_no_completo,'QTD_REP'); for i in 1..v_qtd_rep loop --delete from prest...
asked by 23.11.2016 / 12:27
1
answer

ORACLE date error

Although I have many materials on the subject, nothing has even helped me resolve it. I'm trying to make a simple query in an Oracle database and I get an error, follow the error. OCIStmtExecute: ORA-01843: not a valid month Follow my q...
asked by 19.01.2017 / 19:07
1
answer

ORA-1691: unable to extend lob segment

I'm doing a load from one oracle database to another database and at the time of transferring the files from an attachment table this error occurred after some time: ORA-1691. Reading a little I saw that it is related to storage space but I d...
asked by 17.11.2016 / 14:19
1
answer

Select transforming different records into single

I need to make a select by unifying two different rows into one, with two new columns. I am using bd oracle and there is no possibility to perform update in the tables. Example:     
asked by 05.10.2016 / 22:02
1
answer

Feed Textarea with bank field

I'm trying to do the following: I need to feed a textarea , every minute, with the result of the query below: $consulta = OCIParse($ora_conexao,"Select pcn.romaneio Romaneio...
asked by 23.08.2016 / 13:52
1
answer

Split List with more than a thousand lines - .NET

I'm getting an error while performing this select sb = New StringBuilder sb.Append(" SELECT ") sb.Append(" SE.NU_SERIE_NF, ") sb.Append(" SE.NU_NF, ") sb.Append(" SE.DH_ENTREGA, ") sb.Append(" SE.DH_IMPORTACAO, ") sb.Append(" SE.ARMAZEM, ") s...
asked by 15.08.2016 / 16:44