Questions tagged as 'oracle'

Tagged questions
0
answers

How to read ora_java.object

I find myself with the following inconvenience: a client jar for a webService, this will be integrated with oracle forms through a library.pll When importing java class I care about the following data type: -- Method: getPCODRES ()Ljava/m...
asked by 25.06.2018 / 19:14
1
answer

Problems when viewing the content of an xml in json format using clob

I am trying the code to consult a table, I get the result as XML I convert it into JSON format, and I show it on the screen to perform tests. My problem is that, by showing the JSON in varchar format (with GetStringVal) it works fine, but if the...
asked by 29.06.2018 / 10:12
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 26.06.2018 / 22:23
1
answer

Create table if it does not exist in the database with an ORACLE SQL trigger

As the statement says, I need a trigger that triggers after inserting a record in a table "table0". If the table1 does not exist this trigger must create it and then perform the insert. I had something like this: CREATE OR REPLACE TRIGGER TRG_...
asked by 20.06.2018 / 20:54
0
answers

help on generating a spool

I'm trying to generate a spool but it marks me wrong syntax when I insert in the variable COL Nombre_emp new_value Nombre_emp; SELECT TO_CHAR(TO_DATE(TRUNC(MAX(ID_MES)),'YYYYMM'),'YYYYMM')||'.txt' Nombre_emp FROM estudiante WHERE ID_MES >...
asked by 14.06.2018 / 14:35
1
answer

I do not have Oracle Services

I was installing the Oracle Database 12c Standard Edition 2 but at the time of wanting to log in via SQLPlus, I got booted " ERROR: ORA-12560 ", as I have seen to fix it I have to activate the OracleServiceORCL service, but here is my proble...
asked by 09.06.2018 / 00:02
0
answers

Unzip .zip file (imag1, imag2, imag3) in Java

I find myself in how to unzip a zip that contains images, what I want to do is unzip the file and save the images of type [] to my BD. Help me, please.     
asked by 13.06.2018 / 17:45
0
answers

Oracle JDBC for Java 9

I want to connect Java 9 with an Oracle Database 11g, what JDBC should I download and where should I save the downloaded driver? In previous versions of Java I kept it in the ext folder of the SDK and everything worked perfectly, now, in Java ve...
asked by 10.06.2018 / 06:25
0
answers

oracle 11g SQL plus users

My question is as to the users that I think about SQL command line, I create two users with all the privileges and in the same table space, with user 1 I create a table, but the other user can not see it, nor Even the DBA can see it, I do not kn...
asked by 06.06.2018 / 21:47
1
answer

insert several checkbox in oracle using jsp and servlet

I need help in how to obtain and transform the values of several checkboxes to insert them in the database with a comma, for example: Seleccione sus frutas favoritas: <br> <input type="checkbox" name="frutas" value="manzana">...
asked by 03.06.2018 / 23:54