Questions tagged as 'oracle'

Tagged questions
0
answers

Problem with IIS and PDO oci

I'm uploading a web application, which has a php code, and specifically, PDO code to connect to an oracle database with oci. The problem is that the php that is installed in the IIS, shows several PDO minus the one I need, and in php.ini, it...
asked by 12.02.2018 / 15:07
1
answer

ORA-12170: TNS: Connect timeout occurred in CentOS 7

I am configuring a server in CentOS 7 to connect to an Oracle database within the same network. IP ORACLE = 192.167.10.100 IP SERVER = 192.167.15.123 I have installed the Instant Client Package: Basic, SDK and SQL * Plus. Link Download ....
asked by 10.03.2018 / 06:06
0
answers

I need help to show some information about a query. ORACLE

I have the following query nested with subselects SELECT PEDIDO.ARTICULO , PEDIDO.CANTIDAD_SERVIDA , PEDIDO.LOTE_ARTICULO, PEDIDO.FECHA_VENCIMIENTO, MIN(BULTO.NUMERO_LINE), BULTO.CODIGO_CONTENEDOR , SUM(CANTIDAD_EN_CONTENEDOR) FROM (S...
asked by 19.02.2018 / 20:01
0
answers

oracle encryption with java

It is possible to obtain the same result of the encryption with oracle 10g (DBMS_OBFUSCATION_TOOLKIT.des3encrypt) and of a java version jdk1.6. JAVA CLASS import java.io.UnsupportedEncodingException; import java.security.GeneralSecurityEx...
asked by 09.01.2018 / 00:14
1
answer

Error Oracle.DataAccess can not find Dll

Good morning, I kindly request help with the following error that my web application generates in visual studio 4> C: \ Users \ svictorino \ Documents \ Confidential and privileged \ workspace \ PCCE-V2 \ pcce \ web.config (295): Compile (...
asked by 04.01.2018 / 15:30
1
answer

How to call from a Service Callout to a business asynchronous project service bus Oracle

I am creating a service, in which I need to place a Service Callout in my Pipeline , as I should call a BusinessService where your wsdl has an asynchronous service structure, after this call, depending on the response you return, I must tri...
asked by 21.12.2017 / 18:06
1
answer

oracle express system tables

I just installed the oracle 11 g express, I run the sql developer. I created a database called: November, at the time of expanding the tables I find some tables that seem to be from the system, I would like to know how I do so that they do no...
asked by 10.12.2017 / 06:05
1
answer

Why does not the routine table from the employees table be transferred to the study table as an invalid?

Why when I try to pass the foreign key which is a rut that is inside the table used for studies, it tells me that it is invalid? I attach images of the error and the tables. SQL> CREATE TABLE EMPLEADOS( 2 RUT CHAR(10), 3 NOMBRE VARCHA...
asked by 18.11.2017 / 20:07
1
answer

Filter expressions in SQL query

I am trying to perform a query in SQL Developer (Oracle) on several tables. In which I need to compare the result of expression if it is Greater or Equal (x> = 0) or if it is Minor: X >= 0 => Resultado: 'S' ; X < 0 => Resultad...
asked by 22.03.2018 / 18:03
1
answer

triggers in oracle

I have to build a trigger that when a record is inserted in the table detalle_venta, enter the commission in the commission table, you have to calculate the commission (commission * amount) * 0.05, my trigger compiles, but when I insert a record...
asked by 24.10.2017 / 18:20