Questions tagged as 'oracle'

Tagged questions
1
answer

Error "No matching unique or primary key for this column-list" with a compound station

Doing a job I found the error:    DAN_FACTURA (INVOICE), "No matching unique or primary key for this   column-list " Reviewing my table DAN_FACTURA I checked the statement and, as far as I know, I have correct my syntax for the Prim...
asked by 12.10.2016 / 22:41
0
answers

Optimize Query so as not to overload more temporary tables [closed]

I have the following query structure but when executing it I get the following error: "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" 01652. 00000 - "unable to extend temp segment by %s in tablespace %s" *Cause: Failed...
asked by 08.11.2016 / 15:26
1
answer

Oracle - Identify line in which exception occurs

Someone can tell me how I identify the line of code in which an exception occurs in oracle, what I want to do is when an exception comes up, grab the description and the line and save it in a table of errors, so I can identify in which part of t...
asked by 27.06.2016 / 16:11
1
answer

TRIGGER to prevent deleting record with a specific identifier

I'm doing a job with PL / SQL, oracle and sqldeveloper and I have a table to which I want to create a trigger that prevents me from deleting a record that has an id in the field 1. I do not know how to do it.     
asked by 19.05.2016 / 22:54
1
answer

Error in XMLTYPE in xml with namespaces

The following sql statement is causing me an error LPX-00601: Invalid token in: '/ soap: Envelope / soap: Body / GetRatesTreeResponse'. Could you tell me if you see any failure? WITH mydata AS (SELECT TO_CLOB('<soap:Envelope xmlns:soap="...
asked by 10.05.2016 / 12:35
2
answers

Update sql with join

I am trying to make update where I would need to join to join two tables. I have the table ADJUDICACION and the table PROVEEDOR , in which the join would be: ADJUDICACION.ID_PROVEEDOR = PROVEEDOR.ID . And what I wa...
asked by 08.08.2018 / 14:04
1
answer

Data type Interval in Oracle with C #

I hope you can help me with my problem which is as follows: I have an application made in C# that connects to a database of Oracle , and in turn in this I have a table with a field INTERVAL DAY(2) TO SECOND(6)" (TIEMPOEJECUCIO...
asked by 14.09.2016 / 22:23
1
answer

Call several stored procedures inside another

I have a question about how to call several stored procedures inside another in Oracle. I tried to call them in the following way, but I only run the first one. Does anyone know how I can make the call for all three to run? I am using Oracle PL...
asked by 08.02.2017 / 18:58
3
answers

ORACLE - Insert from a Select

someone helps me solve a problem I have (beats me that is layer 8 :)), well look, if I do this sql works normal: insert into USR_SISTEMAS VALUES ('16469', '2','3') but if the data I want to bring a select as: insert into USR_SISTEMAS (SIS...
asked by 17.03.2017 / 00:45
0
answers

Job oracle runs on its own

I have this job: DBMS_JOB.SUBMIT(RT_job,'pkg_rt_semaforo.prc_rt_semaforo;',sysdate+0.00034722); commit; The sysdate + 30 segundos works fine, I am not parameterizing INTERVALO , but apparently the job is running again and again...
asked by 04.11.2016 / 23:37