1. Parameters to tune when retrieving a lot of small BLOBs (2-10kb) from Oracle DB? stackoverflow.comWe have a table in which we store millions of small BLOBs (2-10kb). And we need to access a portion of this table at a time, iterating through it while retrieving ... |
2. Retrieving Oracle Cursor with JDBC stackoverflow.comI have been experiencing some frustrations trying to make a simple Oracle cursor retrieval procedure work with JDBC. I keep on getting an error of "[Oracle][ODBC][Ora]ORA-06553: PLS-306: wrong number or types of ... |
3. Update/ Retrieve /Inserting date field stackoverflow.comI am having difficulties while updating a date field into the Database. The field type in the DB is Date/Time. Now, I am trying to update the field name "R_Date". Currently, I am ... |
4. problem in setString method.in retrieving data from the table stackoverflow.comi have two tables "Table1" with columns user_name,Password and course ID and another table "course" with columns course_id,course_name.I have used the following code to display the course ID from Table1 according ... |
5. How to retrieve audio file from Oracle database stackoverflow.comWhat is the easiest way to extract .mp3 file from oracle Database using Java? |
6. How to retrieve SDO_GEOMETRY from database using JDBC? stackoverflow.comI am new to Java.I need to retrieve SDO_GEOMETRY from database and convert it into string using jdbc.If any one has sample or idea please share with me. Help would be appreciated. Best ... |
7. Retrieving Results from Oracle coderanch.com |
9. retrieving varray as an oracle object attribute coderanch.com |
10. Retrieving data from Oracle database? coderanch.comHello everyone! I have a problem retrieving data (arabic data)from Oracle database. Bellow is the code for a testing page that should search for a giving name from oracle database and then disply it on the screan. PS: even though the input is a correct data, the search doesn't give me anything back! BTW, I'm using apache tomcat. ANY HELP WILL ... |
13. Retrieving oracle collections with jdbc and jpub generated classes coderanch.comHello I've used JPub to create custom classes for my base type and for a varray of that type. See the signatures of these at the bottom of this message. I've a pl/sql procedure that has an out parameter that is for the array. I get java.lang.ClassCastException when I tried to get the result as a CRDCountryArray. This is my code: ... |
14. Retrieve byte Array stored in Oracle BLOB coderanch.comHi, I've migrated from mySQL to Oracle and am having a problem reading a byte array that I have stored as a BLOB in Oracle. With mySQL the byte array was returned as I wanted, but with Oracle something strange is happening. I'm using iBATIS to access the database. From some googling I've done I think that the byte array I ... |
15. Insert and retrieve image/file into and from database Oracle coderanch.com |
16. Control character when retrieving a field from an Oracle Array coderanch.comHi, I am connecting to an Oracle 9i DB using a web service and fetching data to populate and XML file. The server used here is WAS 6.1. There seems to be an issue with the value returned from a VARCHAR2 field. The data in this field has an asterisk(*). We have a separate application calling this field and we get ... |
17. How to retrieve array elements returned by an Oracle SP coderanch.comI have an Oracle SP that returns a Array. Now, I am trying to retrieve the elements in that array using the following code snippet....but i am facing a java.lang.ClassCastException.... can somebody help me out with this??? i got this code from a tutorial...... cstmt1.registerOutParameter(4, OracleTypes.ARRAY,"PROPLIST"); cstmt1.executeUpdate(); ARRAY propValues = (ARRAY)cstmt1.getArray(4); String[] values = (String[]) propValues.getArray(); for( int i = 0; ... |
18. How to retrieve array elements returned by an Oracle SP coderanch.com |
19. Retrieve documetns from Oracle DB coderanch.com |
20. How to retrieve Oracle SID from java web application coderanch.comHello everybody, Does anybody know of a API that I can use to capture the name of the database that I am connected to? Here is the scenario, I login to my application, now on the first page I want to display the name of the database I am connected to. Let say this is the entry from my tns file: ... |
21. Retrieving date data from MS-Access and inserting into Oracle table dbforums.comHi All, This is my first message to the forum. I am trying to access the data from a mdb file and insert into a oracle table using jdbc. I am getting problems when I am trying to get the data from the date/time field of the mdb file and insert it into the date field of the table. for instance ... |
22. Oracle data is sorted but not getting when retrieve from Resultset forums.oracle.com |
23. Retrieving DATE TIME from Oracle forums.oracle.com |