import « oracle « Java Database Q&A





1. How to accept REF cursor in JAVA without importing Oracle Package    stackoverflow.com

I am writting JAVA programme using JDBC for database conntectivity , I am calling one stored procedure in that which is returning ORACLE REF CURSOR , IS there any way I ...

2. Bulk import from Informix into Oracle    stackoverflow.com

We need to pull some tables from an Informix SE database, truncate tables on Oracle 10g, and then populate them with the Informix data. Does a bulk import work? Will data ...

3. Export an Oracle database, import it to a different user, stored procedures don't work    stackoverflow.com

I export an oracle "schema" using

exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y
and then import it into a different schema on the same oracle instance on the same SID using ...

4. import the oracle dump programatically through java?    stackoverflow.com

is there a way to import the oracle dump through java program?? If yes, How?? Thanks in advance

5. Import CSV file to oracle DB    stackoverflow.com

Is there a simple Java library or approach that will take a SQL query and load data in a CSV file to oracle database. Pls help

6. Oracle BI reports importing template    stackoverflow.com

I am trying to import a report in Oracle BI publisher from a PDF generated by other software, Is it possible I can write java code if that can help to ...

7. I include an external .jar, but i'm asked to import his libs    stackoverflow.com

I succeed to include ojdbc14_g.jar to my project, but i am asked to import OracleConnectionPoolDataSource wich is included in ojdbc14_g.jar. Here is my code:

<path id="myclasspath">
      <fileset dir="lib/">
 ...

8. How to Export Oracle DB and Import all DB objects into Oracle XE    stackoverflow.com

Oracle Newbie Here: I am connecting to an Oracle Server outside our region but our app seems to run slow. I am thinking of setting it up locally on my Oracle 10G XE database ...

9. Oracle imports    coderanch.com

I am currently writing my first Java program which is intended to talk to an Oracle database. I have an Oracle db setup, version 8i. I have looked through online tutorials as to how to make my db query an Oracle db. However, "import oracle.sql.*" and "import oracle.jdbc.driver.*" give me the error "Package oracle.sql not found in import". Through reading this ...





10. Problem in importing oracle.sql.*    coderanch.com

11. importing oracle.sql.*    coderanch.com

12. Export and import tables in Oracle    coderanch.com

13. problem importing oracle.jdbc.pool.OracleDataSource and sealing violation    forums.oracle.com

Hi there; It's been two days that i have been trying to fix this issue due , probably to its complexity. I have written a web application that i managed to deploy and run using Sun Application Server 8.That was a week or so. Now i had to modify some details in my database, since i use an Oracle Db that ...

14. Oracle export import problem    forums.oracle.com

Process p = rt.exec("expdp xpslperf/dba@APPN QUERY=dev_performance:\"WHERE TIME_NUM > 1204884480100\" DUMPFILE=JAVA_EXP_DEV.dmp tables=XPSLPERF.dev_performance"); } catch (Exception e) { e.printStackTrace(); } } } ==================================================================================== it doesnot do anything ... if i provide a log file option it is listing as below: ==================================================================================== ;;; Export: Release 11.1.0.6.0 - Production on Monday, 05 May, 2008 18:33:48 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected ...

15. Importing an Oracle DB    forums.oracle.com

I thought it might have to do with the file not being fully extracted , and just to make sure , put fout.write(b) in a thread. But still the same error exists. I also noted tht the code works well if the dmp file is specified manually rather than extracted at runtime. Below i have given the code that used threads ...

16. Importing Java.lang.Exception into Oracle Forms with toString included    forums.oracle.com

Hi, I am creating a web service client via Forms and need to debug a java exception. I have got many examples off google for doing this but they all incude using a toString() method which I dont seem to have access to. Using the Oracle documentation (http://www.oracle.com/technetwork/developer-tools/forms/documentation/forms-soa-wp-1-129441.pdf) I followed instructions to import java.lang.Exception, It states that it the generated package ...