Questions tagged as 'oracle'

Tagged questions
3
answers

Trigger Oracle with sysdate

I have a trigger in a simple database, what I want that trigger to do is generate an id with characters and numbers, but it does not work. I hope you can help me, I thank you very much.     
asked by 26.09.2017 / 03:11
1
answer

character set mismatch COALESCE

Hi, I have a problem with this query, it tells me the error ORA-00932: inconsistent datatypes: expected NCHAR got NUMBER 00932. 00000 - "inconsistent datatypes: expected %s got %s" *Cause: *Action: Error en la línea: 54, columna: 43 I...
asked by 03.09.2017 / 03:20
1
answer

sql query from vb6 to oracle

I need to insert an insert from VB6 to an Oracle database, I changed the procedure, according to the help they already gave me, respecting the Oracle syntax. but now I get Now I get the error "invalid column name", could you help me with some id...
asked by 30.08.2017 / 14:49
1
answer

Error ORA-12541 TNS: There is no listener

I have problems connecting to the Oracle database from Visual Studio 2008, I get that error, but the funny thing is that when doing the TEST of this same connection in Orbit data odbc, the connection is successful. Check the tnsnames.ora file an...
asked by 04.09.2017 / 16:54
1
answer

Error java.sql.sqlexception no suitable driver found for jdbc sqldeveloper

Could you help me with this error? I have a database in sql developer, I have created it with a table that includes users and passwords. Create a program with a login, I have programmed the button, I have created my connection class and...
asked by 22.08.2017 / 02:32
1
answer

perform update on a table in oracle using php

I'm doing a project in php but it does not allow me to perform an update on a table and I tried several times and I get the same error Warning: oci_parse() expects parameter 1 to be resource, null given in gpersonal.clase.php on line 18...
asked by 11.08.2017 / 23:58
0
answers

How to send the data of an XML (I am the client) to a WDSL

Greetings, I have an Oracle DB that creates an XML file that contains data that I need to be able to send or consume to a WSDL. I already have the XML ready, but what I do not know is how to send the file or the information.     
asked by 11.08.2017 / 18:30
1
answer

Generate fixed tuples for each tuple of a result

I have 3 tables: areas , roles and personas . I generate a hierarchy based on them where personas hang from their role, each role hangs from its area , and all areas of a fixed tuple. The basic query that I leave...
asked by 17.08.2017 / 22:09
1
answer

Inputbox from php and oracle

I want to show as options the result of this query to later use them. $qsucursal = oci_parse($conn, 'SELECT Id_Sucursal, Sucursal FROM TblSucursales;'); //Consulta oci_execute($qsucursal);//Ejecutando consulta I go through the results and p...
asked by 28.08.2017 / 21:16
1
answer

oracle - select script with detail of all the tables

I am developing a query to 3 tables which contains the fields name and code and I would like to make a selection of these by bringing the data as follows: Table1Code Table1Codigo.Table2Codigo Table1Codigo.Tabla2Codigo.Tabla3Codigo Tabl...
asked by 24.08.2017 / 06:04