Questions tagged as 'oracle'

Tagged questions
2
answers

Install OCI8 in PHP for XAMPP in OSX Yosemite

Good morning, everyone. I am trying to install OCI8 for connection to an Oracle database on my XAMMP 5.6. I have followed the guide that they mark in PHP, installing the Instant Client of Oracle and downloading from PECL the OCI8 for my ve...
asked by 21.11.2016 / 15:49
1
answer

Export packages with "dbms_metadata.get_ddl"

I am exporting packages using dbms_metadata.get_ddl . For example: select dbms_metadata.get_ddl('PACKAGE_BODY','NOMBRE_PAQ','SCHEMA_NA‌​ME') from dual; But when generating the spool with the package code, a blank line is generated bef...
asked by 28.11.2016 / 15:15
2
answers

Consult a segmented field

I have two tables which one is created from the data of the other fields: CREATE TABLE1( CAMPO1 VARCHAR2(15), CAMPO2 VARCHAR2(15), CAMPO3 VARCHAR2(5), CAMPO4 VARCHAR(20)); CREATE TABLE2( CAMPO1 VARCHAR(20), CAMPO2 VARCHAR(30)); I want to i...
asked by 22.11.2016 / 16:30
0
answers

ORACLE - Redefine a table with Enterprise Manager

When it comes to reorganizing the contents of a table using the Enterprise Manager, it asks me for host credentials. The truth is that I do not know what goes there. I have tried with the Oracle accounts but they all give me the following error:...
asked by 14.11.2016 / 11:45
1
answer

WSO2 ESB connector oracle c # asp.net

I am using WSO2 Enterprise Service Bus (ESB) to use it as a WSDL data bus ... but now they are asking me to use another service that is capable of sending a query with parameters, from my application ( ASP.Net C # ) call it passing the param...
asked by 18.05.2016 / 11:48
0
answers

Include columns without records

SELECT TRIM(e.APELLIDO1) "PRIMER APELLIDO", TRIM(e.APELLIDO2) "SEGUNDO APELLIDO", TRIM(e.NOMBRE1)||' '||TRIM(e.NOMBRE2) "NOMBRES", e.NUMDOCUMENTO AS "DOCUMENTO DE IDENTIDAD", e.SEXO AS "GENERO", (CASE WHEN c.CODCARGOTIPO = 1 THEN 'DOCE...
asked by 18.05.2016 / 15:33
3
answers

Insert data (ID) in oracle from PHP

I'm trying to insert data into an Oracle database. The problem is in the ID of the table. In mysql it is done with auto_increment but from oracle with sequences. This is my insert code: $stid = oci_parse($conn, 'INSERT INTO usuarios (iduser...
asked by 15.05.2018 / 22:53
1
answer

PL-SQL perform query using null filters or not

Is there any way I can concatenate to a select a query according to a condition? for example in I have a procedure in which I will receive N input parameters, the query I have it ready but since they are filters not all parameters will come with...
asked by 03.03.2018 / 17:24
3
answers

Prevent deleting more than one record at a time with a trigger in Oracle

I need to implement something similar to what SQLServer does but in Oracle: CODE: SQLSERVER CREATE TRIGGER TR_ImpideBorradoMultiple ON MiTabla AFTER DELETE AS BEGIN IF(SELECT COUNT(*) FROM Deleted) > 1 Begin raiserror('Pr...
asked by 21.07.2017 / 14:43
1
answer

SqlBulcopy WriteToServer method takes too long vb.net

When creating an object of the class sqlBulkCopy and sending the method writeToServer , passing it as parameter a OracleDataReader this delay more than 15 minutes, the number of rows that I want to copy are close to 140000, I...
asked by 25.10.2017 / 23:36