ORA-17004 - Invalid column type
ORA-17004 - Invalid column type
Questions tagged [ora-17004]
8 questions
6
votes
2 answers
Using Types.NVARCHAR with oracle JDBC driver to work with Cyrillic chars
I am trying to use the "New Methods for National Character Set Type Data in JDK 1.6", to get a standard JDBC solution to handle cyrillic chars, but when the execution reaches any line with NVARCHAR type, for instance:
preparedSelect.setObject(3,…
L. Holanda
- 4,432
- 1
- 36
- 44
3
votes
2 answers
How to Oracle XMLTYPE in Hibernate
One of the column is of the type XMLTYPE in Oracle database.
In my application, I want to persist the data and using Hibernate.
I did the following for mapping XMLTYPE in hibernate
Define the custom user type implementing UserType
The custom user…
Kiru
- 169
- 6
- 13
2
votes
1 answer
Can I return a table of custom object as an OUT parameter when calling stored procedure in JDBC
In Oracle 11g I have a stored procedure like this:
PROCEDURE test_params (o_message_tbl OUT core.message_tbl);
where
create or replace TYPE message_tbl AS TABLE OF core.message_obj;
create or replace TYPE message_obj AS OBJECT
(code…
Infeligo
- 11,715
- 8
- 38
- 50
2
votes
5 answers
ResultSet.getBlob() Exception
The Code:
ResultSet rs = null;
try {
conn = getConnection();
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while (rs.next()) {
Blob blob = rs.getBlob("text");
byte[] blobbytes = blob.getBytes(1,…
John
1
vote
1 answer
Date related methods of result set is not working
Am using jdk- 1.6,
os- redhat 5,
driver- class12.jar,(jar along with jdk lib)
db-Oracle 10i
Code:-
public Timestamp getCurrentTimeStamp(Connection connection) throws SQLException {
…
user735936
- 29
- 3
- 7
1
vote
0 answers
Oracle error code [17004] Invalid column type for java.time.Instant
I get the following exception while trying to store instance of java.time.Instant into Oracle table where the column is of type TIMESTAMP WITH TIME ZONE:
SQL state [99999]; error code [17004]; Invalid column type; nested
exception is…
James Jithin
- 10,183
- 5
- 36
- 51
1
vote
2 answers
Interoperability between Weblogic 10.3.1 and Oracle BPM 10.3.1
Im migrating an ALBPM 6.5 running on a WLS 10.0 to an Oracle BPM 10.3.1 running on WLS 10.3.1
I got some problems with the Oracle driver because the old driver (weblogic.jdbcx.oracle.OracleDataSource) was definitely removed from the server and is…
alfredozn
- 314
- 3
- 16
0
votes
3 answers
How do I use PL/SQL to_date with a variable in Groovy?
I've got the following small Groovy script that just does a count of rows in the database for a specific date.
import groovy.sql.Sql
def today= new GregorianCalendar()
def dateString =…
MattGrommes
- 11,974
- 9
- 37
- 40