How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Support for Other Oracle9 i Datatypes → variables in the same way that any standard Java type can be used. This includes the classes … oracle.sql.RAW classes. Because the oracle.sql.* classes do not require conversion to Java type format
General Use of SQLJ Streams → functionality required by SQLJ. This functionality is to communicate to SQLJ the type and length of the
Using SQLJ Streams to Retrieve Data → iterator that has a column of the appropriate SQLJ stream type. This section covers the basic steps in … last column being of the appropriate SQLJ stream type. Declare a local variable of your iterator type … . Declare a local variable of the appropriate SQLJ stream type. This will be used as a host variable
SQLJ Stream Objects as Output Parameters and Function Return Values → Output Parameters You can use the types BinaryStream and CharacterStream as the assignment type for … types BinaryStream and CharacterStream as the assignment type for a stored function return result
Retrieving Data into Streams: Precautions → You can also use the SQLJ stream classes to retrieve data, but the logistics of using streams make certain precautions necessary with some database products. When reading long data and writing it to a stream using Oracle9 i and an Oracle JDBC driver, you must be careful in how you access and process the stream data. As the Oracle JDBC drivers access data from an iterator row, they must flush any stream
Support for Oracle REF CURSOR Types → , but REF CURSOR itself is a type specifier, not a type name. Instead, named REF CURSOR types must be … specified. The following example shows a REF CURSOR type specification: TYPE EmpCurType IS REF … stored procedure or function can declare a variable of some named REF CURSOR type, execute a SELECT
Support for Oracle ROWID → The Oracle-specific type ROWID stores the unique address for each row in a database table. The … class oracle.sql.ROWID wraps ROWID information and is used to bind and define variables of type ROWID … . Variables of type oracle.sql.ROWID can be employed in SQLJ applications connecting to Oracle9 i in … use the type
Support for BLOB, CLOB, and BFILE → (character LOB)--and provide similar support for the Oracle-specific BFILE type (read-only binary files … . Note that the type of the chunk being read or written depends on the kind of LOB being manipulated. For … time. Note that the chunk host variable is of the type String. Example: Use of oracle.sql.BLOB … host variable is
Package oracle.sql → SQLJ users, as well as JDBC users, should be aware of the oracle.sql package, which includes classes to support all the Oracle9 i datatypes (for example, oracle.sql.ROWID, oracle.sql.CLOB, and oracle.sql.NUMBER ). The oracle.sql classes are wrappers for the raw SQL data and provide appropriate mappings and conversion methods to Java formats. An oracle.sql.* object contains a binary representation
Summary of Supported Types → to a Java variable is converted to the corresponding Java type. A Java variable input to SQL is … converted to the corresponding Oracle datatype. Table 5-1 Type Mappings for Supported Host Expression … Types Java Type OracleTypes Definition Oracle SQL Datatype STANDARD JDBC 1.x TYPES boolean BIT … implementing oracle.sql.ORAData
Using PL/SQL BOOLEAN, RECORD Types, and TABLE Types → Oracle SQLJ and JDBC do not support calling arguments or return values of the PL/SQL BOOLEAN type … unsupported type, you can create wrapper procedures that process the data using supported types. For
Extended Support for BigDecimal → SQLJ supports java.math.BigDecimal in the following situations: as host variables in SQLJ executable statements as return values from stored function calls as iterator column types Standard SQLJ has the limitation that a value can be retrieved as BigDecimal only if that is the JDBC default mapping, which is the case only for numeric and decimal data. (See Table 5-1 for more information about JDBC
Support for Streams → Standard SQLJ provides two specialized classes, listed below, for convenient processing of long data in streams. These stream types can be used for iterator columns to retrieve data from the database, or for input host variables to send data to the database. As with Java streams in general, these classes allow the convenience of processing and transferring large data items in manageable chunks. sqlj.runtime.BinaryStream
Type Property → Feedback Type Property See Also Applies To OraField OraParameter OraParamArray Description Returns the … variant type of the specified object. Not available at design time and read-only at run time. Usage … data_type = orafield.Type data_type = oraparameter.Type data_type = oraparamarray.Type Remarks
Examples of Retrieving and Processing Stream Data → This section provides examples of various scenarios of retrieving stream data, as follows: using a SELECT statement to select data from a LONG column and populate a SQLJ CharacterStream column in a named iterator using a SELECT statement to select data from a LONG RAW column and populate a SQLJ BinaryStream column in a positional iterator Example: Selecting LONG Data into CharacterStream Column of
Using SQLJ Streams to Send Data → stream class (depending on the type of data), passing the data object and length (as an int ) to the
Backward Compatibility for Previous Oracle JDBC Releases → the Oracle type extensions supported by the Oracle9 i JDBC drivers are either not supported or … support BLOB, CLOB, and BFILE. Table 5-3 summarizes these differences. Table 5-3 Type Support … Differences for Oracle 8.0.x and 7.3.x JDBC Drivers Java Type (Oracle Extensions) Oracle Types Definition