Questions tagged as 'oracle-11g'

Tagged questions
1
answer

Help adding the following query (ORACLE)

I have the following selection which I need to add the amount when the same item is repeated in the same container and lot. SELECT LOTE,FECHA_CADUCIDAD,CANTIDAD,CODIGO_CONTENEDOR,ARTICULO,NUMERO_PEDIDO FROM XXOSI.XXOSI_OMBULLN_SIS_IN_T WHERE...
asked by 23.02.2018 / 21:09
0
answers

How to send a string to the IN clause in the stored procedure (oracle)

I find myself doing select to a table by means of where campo in (id1,id2...) . My doubt arises in how to send the string as an input parameter to the Oracle stored procedure. Then I present what I have tried so far. From C # I s...
asked by 23.02.2018 / 02:03
0
answers

GRANT EXECUTE ON SYS.UTL_FILE

Algien knows why he sent me this error SQL> conn system Enter password: Connected. SQL> GRANT EXECUTE ON SYS.UTL_FILE TO pld; GRANT EXECUTE ON SYS.UTL_FILE TO pld * ERROR at line 1: ORA-00942: table or view does not exis...
asked by 13.02.2018 / 19:03
0
answers

NAGIOS Problem when executing command with check_oracle

I am currently doing the end of cycle project and decided to mount a Nagios to monitor an Oracle server. The monitoring of the resources of the machine has been correct, but when it comes to monitoring Oracle services I have some problems. I...
asked by 01.02.2018 / 12:21
1
answer

Fatal error: Uncaught Error: Call to undefined function oci_connect () in C

Greetings! I was working with PHP Version 5.4.3 connected 2 Databases (Oracle Database version 10g Enterprise Edition Release 10.2.0.5.0 - 64bit) (version Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit) When I upgrade to PH...
asked by 22.01.2018 / 22:26
1
answer

Trigger with compilation errors

Well it turns out that I want to make a trigger that when I update a column in a specific table records are annexed ie I have a table where articles when the sale is made and the quantity is discounted that information is given to a sales table....
asked by 17.12.2017 / 21:36
0
answers

import bbdd error ORA-00038

When trying to import a database using the statement: imp system/system@xe file=database.dmp log=importLog.log full=y; Launches me an error:    IMP-00038: Could not convert to environment character set's handle Reading by sta...
asked by 15.12.2017 / 14:17
0
answers

ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

Good afternoon, what happens is that I have an error when trying to create a connection in SQLDeveloper "Status: Fail: Failed to test: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of...
asked by 03.12.2017 / 21:14
0
answers

relate nested table attribute to attribute of another table in OOO oracle

Hello as the title says I need to relate the attribute Id_libro of nested table that is in the table Prestamo with an Id_libro attribute of the table Books in POO oracle, a kind of foreign key so that there are no errors that in a loan t...
asked by 29.11.2017 / 20:08
1
answer

How do I access EJB Remote from a different EAR on WebLogic 11g?

I'm doing an application in WebLogic 11g (WebLogic 10.3.6), this server uses JDK6, I want to access a Remote EJB from an EAR different from the one that contains the EJB, I'm working in Eclipse Oxygen with the OEPE tools, my code is this: Re...
asked by 10.11.2017 / 21:50