Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORACLE LONG to JAVA?

Re: ORACLE LONG to JAVA?

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 15 Nov 2004 09:24:51 -0800
Message-ID: <26703915.0411150924.22d19066@posting.google.com>


Alex Sauer <noSpamm_at_web.de> wrote in message news:<2vq2nmF2nvq0jU1_at_uni-berlin.de>...
> Hi everybody,
>
> I got a problem of reading LONG-Datatyps into my Java-program using JDBC
>
> I send out sth. like "SELECT search_condition FROM user_constraints" to
> the DB. (Should return "OWNER", "CONSTRAINT_NAME", "CONSTRAINT_TYPE",
> "TABLE_NAME", "SEARCH_CONDITION", ...)
> Sending this statement via "rsSet = stmt.executeQuery(sql)" and fetching
> the results into a resultSet, all works fine.
>
> And while accessing column 1 - 4 it works out fine.
>
> But if I try to access the "search_condition", the program alway tells
> me, that the stream was already closed.
>
> According to some documentation I found, this columns datatype is LONG.
>
>
> Can someone plz tell me how to get a dammned LONG into an JAVA-appl.?
> PLZ help me!
>
>
>
>
> Kind regards
> Alex

IIRC with getAsciiStream.

regards

s.kapitza Received on Mon Nov 15 2004 - 11:24:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US