All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class oracle.sql.CLOB 

oracle.sql.CLOB
public class CLOB
implements Clob

Method Index

o getAsciiOutputStream()
Oracle extension.
o getAsciiStream()
Implements the Clob interface method.
o getBufferSize()
Oracle extension.
o getCharacterOutputStream()
Oracle extension.
o getCharacterStream()
Implements the Clob interface method.
o getChars(long, int, char[])
Oracle extension.
o getChunkSize()
Oracle extension.
o getConnection()
Oracle extension.
o getSubString(long, int)
Implements the Clob interface method.
o isConvertibleTo(Class)
Test whether this data object can be converted to the specified Java data type.
o length()
Implements the Clob interface method.
o position(Clob, long)
Implements the Clob interface method.
o position(String, long)
Implements the Clob interface method.
o putChars(long, char[])
Oracle extension.
o putString(long, String)
Oracle extension.
o toJdbc()
Convert this data object into its default Java object type.

Methods

o length 
 public long length() throws SQLException
Implements the Clob interface method. Returns the number of characters in the CLOB value designated by this Clob object.

Returns:
length of the CLOB in characters
Throws: SQLException
if there is an error accessing the length of the CLOB
o getSubString 
 public String getSubString(long pos,
                            int length) throws SQLException
Implements the Clob interface method. Returns a copy of the specified substring in the CLOB value designated by this Clob object. The substring begins at position pos and has up to length consecutive characters.

Parameters:
pos - the first character of the substring to be extracted. The first character is at position 1.
length - the number of consecutive characters to be copied
Returns:
a String that is the specified substring in the CLOB value designated by this Clob ob ject
Throws: SQLException
if there is an error accessing the CLOB
o getCharacterStream 
 public Reader getCharacterStream() throws SQLException
Implements the Clob interface method. Gets the Clob contents as a Unicode stream.

Returns:
a Unicode stream containing the CLOB data
Throws: SQLException
if there is an error accessing the CLOB
o getAsciiStream 
 public InputStream getAsciiStream() throws SQLException
Implements the Clob interface method. Gets the CLOB value designated by this Clob object as a stream of Ascii bytes.

Returns:
an ascii stream containing the CLOB data
Throws: SQLException
if there is an error accessing the CLOB value
o position 
 public long position(String searchstr,
                      long start) throws SQLException
Implements the Clob interface method. Determine the character position at which the given substring

Parameters:
searchstr - is the substring to search for.
start - is the position at which to begin searching.
Returns:
the position at which the substring appears, else -1.
o position 
 public long position(Clob searchstr,
                      long start) throws SQLException
Implements the Clob interface method. Determine the character position at which the given substring

Parameters:
searchstr - is the substring to search for.
start - is the position at which to begin searching.
Returns:
the position at which the substring appears, else -1.
o getChars 
 public int getChars(long pos,
                     int length,
                     char buffer[]) throws SQLException
Oracle extension. Return copy of the substring of the CLOB at the requested position.

Parameters:
buffer - is the buffer into whcih the characters are read.
pos - is the first character of the substring to be extracted.
length - is the number of consecutive character to be copied.
Returns:
the actual number of characters read.
o getCharacterOutputStream 
 public Writer getCharacterOutputStream() throws SQLException
Oracle extension. Write Unicode stream to the CLOB.

Returns:
a Unicode character output stream.
o getAsciiOutputStream 
 public OutputStream getAsciiOutputStream() throws SQLException
Oracle extension. Write ascii stream to the CLOB.

Returns:
a ascii output stream.
o getConnection 
 public OracleConnection getConnection() throws SQLException
Oracle extension. Get connection object.

o putChars 
 public int putChars(long pos,
                     char chars[]) throws SQLException
Oracle extension. Write characters at the requested position.

Parameters:
pos - is the position to write characters.
chars - is the buffer of characters to be written.
Returns:
the actual number of characters written.
o putString 
 public int putString(long pos,
                      String str) throws SQLException
Oracle extension. Write Java string at the requested position.

Parameters:
pos - is the position to write characters.
str - is the Java string to be written.
Returns:
the actual number of characters written.
o getChunkSize 
 public int getChunkSize() throws SQLException
Oracle extension. Get database LOB storage chunk size.

Returns:
the size in terms of characters.
o getBufferSize 
 public int getBufferSize() throws SQLException
Oracle extension. Get ideal LOB db access buffer size.

Returns:
the size in terms of characters.
o toJdbc 
 public Object toJdbc() throws SQLException
Convert this data object into its default Java object type.

Returns:
this object.
Throws: SQLException
if any of the lower layer code throws an exception.
o isConvertibleTo 
 public boolean isConvertibleTo(Class jClass)
Test whether this data object can be converted to the specified Java data type.

Parameters:
jClass specifies - the Java data type to test against.
Returns:
true if this data object is convertible to the specified Java class, and a corresponding xxxValue() method is available; otherwise, a false is returned. 
All Packages  Class Hierarchy  This Package  Previous  Next  Index