Questions tagged as 'oracle-11g'

Tagged questions
0
answers

ORACLE SQL CURSORS

We are doing a job for the university for the subject Databases One of the sections asks us to create a PROCEDURE with cursors We do not have much idea but we have tried to do it. We have 3 tables: exit, company_transport, seed with the...
asked by 12.08.2018 / 21:21
0
answers

ORACLE Stored procedure to avoid records of dates included in a range of dates

My Training table is this: CREATE TABLE training( id_training NUMBER, id_user NUMBER, start_training DATE, end_training DATE ); The problem that arises is when I have a user (any user) with a date of...
asked by 02.08.2018 / 16:37
0
answers

I get this error when connecting to the database "I / O error: Invalid number format for port number"

This is what I have inside the properties file: hostname=localhost port=1521 database=xe username=xxxxxxx password=xxxxxxx jndi =dbp_props And here the code package ConexionBD; import java.io.IOException; import java.io.InputStre...
asked by 13.09.2018 / 02:59
1
answer

how to make bulk insert with hibernate and Java?

I have a problem, I need to insert thousands of records that are read from a file.properties, the idea is to make bulk insert but when I execute the batch it asks me that the ID of the table is not NULL, I do not understand why it asks for it, H...
asked by 31.07.2018 / 02:13
0
answers

Error in connection pool Jboss - Oracle 11g

I have the following situation: I have a database Oracle 11g , a user login to it, the profile it belongs to has the number of sessions in UNLIMITED On the application server I have a JBoss 7 AS with a connec...
asked by 31.07.2018 / 05:42
0
answers

Help Error ORA-01422 ORACLE

I created a trigger so as not to insert the same user with the same chat two or more times, but I miss this error exact fetch returns more than one requested number of rows tips This is my trigger: CREATE OR REPLACE TRIGGER OCEX_VER...
asked by 07.08.2018 / 20:22
0
answers

Pass type BLOB in trigger

I have a trigger where based on the current status of a column, I make an insert in another table. Everything seems to work correctly, except the passage of the data of an attribute that is BLOB. This attribute is passed NULL. I have this pro...
asked by 16.07.2018 / 20:22
0
answers

Remove composite from soa server 11g

How can I purge my soa server since after several deployed compounds it no longer responds, after some time without any request the server ends in unknown status     
asked by 27.06.2018 / 02:11
0
answers

Error connecting a program with an Oracle database

I'm trying to connect a Java program with a database made in SQLPlus Oracle 11g, at first the connection worked but then I got the following error: java.sql.SQLRecoverableException: Error de E/S: The Network Adapter could not establish the con...
asked by 27.06.2018 / 00:23
0
answers

how to use an update statement in java web?

I'm trying to modify data in a table with the update statement in java web, use a servlet to capture the data and send it to a java class called " adoproducto " with a method called " Modify "that receives two parameters id (type integer...
asked by 12.06.2018 / 18:06