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


Concepts and Administration, 9i Release 2 (9.2.0.2)

Initialization Parameters

TypeInteger

Concepts and Administration, 9i Release 2 (9.2.0.2)

Initialization Parameters

TypeString

Concepts and Administration, 9i Release 2 (9.2.0.2)

Initialization Parameters

TypeString

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

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

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

Supported Types and Requirements for JDBC 2.0Oracle JDBC under JDK 1.1.x supports oracle.jdbc2 extensions to mimic JDBC 2.0 type functionality … Reference. Table 5-2 Correlation between Oracle Extensions and JDBC 2.0 Types   JDBC 2.0 Type Oracle … instance of a Java type in a SQL column. DISTINCT --A distinct SQL type represented in or retrievable … from

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

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

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

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

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

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

Supported Types for Host Expressionscomplete list of legal Java mappings for each Oracle SQL type, see the reference information in the … results. Do not rely on translation-time type-checking alone to ensure the correctness of your code.

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

Key Aspects of Stream Support ClassesThe following abbreviated code illustrates key aspects of the BinaryStream class--what it extends, constructor signatures, and key method signatures: public class sqlj.runtime.BinaryStream extends sqlj.runtime.StreamWrapper { public sqlj.runtime.BinaryStream(java.io.InputStream); public sqlj.runtime.BinaryStream(java.io.InputStream,int); public java.io.InputStream getInputStream(); public int getLength();