August 2001
Intermediate to advanced
400 pages
9h 28m
English
Content preview from Java Programming with Oracle SQLJ
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
7.3. LONG and LONG RAW Columns
To access LONG and LONG RAW columns, you can use the SQLJ stream classes. SQLJ stream classes are subclasses of the java.io.InputStream and java.io.OutputStream Java classes, and are contained in the sqlj.runtime package. There are three SQLJ stream classes that may be used to define SQLJ host objects:
AsciiStream
-
An AsciiStream host object is used to process ASCII text to be stored or retrieved from a LONG column. You can also use an AsciiStream host object to read VARCHAR2 columns rather than using a Java string to store the content. You might want to do that if a VARCHAR2 column contains a lot of data.
BinaryStream
-
A BinaryStream host object is used to process binary data to be stored or retrieved from a LONG RAW or RAW column. A RAW column has a capacity of 4KB, smaller than the 2GB capacity of a LONG RAW column.
UnicodeStream
-
A UnicodeStream host object is used to process text in the Unicode character set to be stored or retrieved from a LONG or VARCHAR2 column. Unicode uses a two-byte character set and can represent over 65,000 characters. Unicode may be used to represent non-English characters.
I use two new tables in this section:
long_content
-
Contains a LONG column named long_column.
long_raw_content
-
Contains a LONG RAW column named long_raw_column.
Both tables also contain a column to store the name of the file from which content was read. The two tables are defined as follows:
CREATE TABLE long_content ( file_name VARCHAR2(40) ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.