Questions tagged as 'oracle'

Tagged questions
0
answers

Timeout for OracleConnection

I have a function to open the banks connection in Oracle and in this function I want to put a time limit on the attempt to connect to the bank. I tried to use ConnectionString this way oConexao.ConnectionString = "Data Source = MeuBd...
asked by 09.10.2014 / 13:46
1
answer

Oracle Database 11G R2 start service

How do I start the Oracle database service? I installed the version 11G R2 for DESKTOP on Windows.     
asked by 01.08.2014 / 03:38
1
answer

Extract value, procedure

Initially I needed to create a procedure that read an xml file and put the data into an oracle table, create the table, the directory, I have the following structure: create or replace package body PACK_GUSTAVO1 as v_id INFO_XML.ID...
asked by 08.12.2014 / 00:34
0
answers

Error in a Trigger involving Linked Server

I created a Trigger that fetches data from a SQL Server table and writes or updates data from another table in Oracle if there is a change. All this via LinkedServer. But running it generates the following error:    The OLE DB provider "OraOL...
asked by 02.06.2014 / 16:52
0
answers

Creating a Network Panel in PHP

I have the following question I have an oracle database with all the names and ip of the users. I would like to use this database in this code instead of using this array would like? <!-- painel.php --> <html> <head> <ME...
asked by 18.12.2014 / 13:25
1
answer

XML import for Oracle tables

. Hello, I need to import an XML file into an oracle table. There are several examples on the internet, but none of them worked for me. In general, I'm having the error: LPX-00210: expected '<' instead of '�' ORA-06512: at "SYSTEM.LOAD_XM...
asked by 30.06.2014 / 00:32
1
answer

Execute stored procedure in oracle database in PHP

I have procedure " example1 " which receives 3 input parameters and none output, how do I execute it in PHP . That would be the case. EXEC "exemplo1"('para1','para1','para3'); $sql = 'EXECUTE "PORTAL_importaXml"'. "(?,?,?...
asked by 03.09.2018 / 21:42
1
answer

Auto-increment ORACLE / PLSQL

Nome Idade ID João 5 Lucas 5 João 2 Lucas 1 I would like to use a cursor to sort by names and by age and that the ID field would be populated according to the sequence, eg Nome Idade ID João 2 1 J...
asked by 28.01.2018 / 21:34
1
answer

Oracle does not export all tables

I am doing an export by the database in a 11.2.0.1.0 full instance, however when checking the log I realize that the tables that have no record are not exported. command that I am using to export the database exp system/senh...
asked by 02.06.2017 / 22:44
2
answers

Error java.lang.NoClassDefFoundError

I'm stuck on a project that should be a "bank" with a CRUD account and transaction. I have to use Oracle database because of the facul. This error happens when giving an insert in the database. Stacktrace: jun 11, 2017 4:21:58 PM com.sun.f...
asked by 11.06.2017 / 21:41