You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for TYPE


1 to 20 of 9357 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Support for Other Oracle9 i Datatypesvariables 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

General Use of SQLJ Streamsfunctionality required by SQLJ. This functionality is to communicate to SQLJ the type and length of the

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Using SQLJ Streams to Retrieve Dataiterator 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 Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

SQLJ Stream Objects as Output Parameters and Function Return ValuesOutput 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Retrieving Data into Streams: PrecautionsYou 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Support for Oracle ROWIDThe 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Package oracle.sqlSQLJ 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Summary of Supported Typesto 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Using PL/SQL BOOLEAN, RECORD Types, and TABLE TypesOracle 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Extended Support for BigDecimalSQLJ 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Support for StreamsStandard 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

Objects for OLE, 9i Release 2 (9.2.0.2)

Type Property

Type PropertyFeedback 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Examples of Retrieving and Processing Stream DataThis 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Using SQLJ Streams to Send Datastream class (depending on the type of data), passing the data object and length (as an int ) to the

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Backward Compatibility for Previous Oracle JDBC Releasesthe 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

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Support for JDBC 2.0 LOB Types and Oracle Type Extensionsstandard JDBC type: BigDecimal JDBC 2.0 functionality for user-defined SQL objects (both weakly and

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

5 Type SupportOracle7. This is followed by details about support for streams and Oracle type extensions. SQLJ … Types for Host Expressions Support for Streams Support for JDBC 2.0 LOB Types and Oracle Type Extensions

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Stream Class Methodsused to receive the stream data can be either a SQLJ stream type or the standard java.io.InputStream … type or java.io.Reader type (as applicable). In either case, standard methods of the input data object … are supported. If the local stream variable is a SQLJ stream type-- BinaryStream or CharacterStream