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 RECORD


21 to 40 of 1376 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

RENAME_COLUMN Member ProcedureRenames a column in an LCR. Syntax MEMBER PROCEDURE RENAME_COLUMN( from_column_name IN VARCHAR2, to_column_name IN VARCHAR2, value_type IN VARCHAR2 DEFAULT '*'); Parameters Table 108-20 RENAME_COLUMN Procedure Parameters Parameter Description from_column_name The existing column name value_type The type of value for which to rename the column. Specify old to rename the old value of the column. An

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

GET_LOB_OPERATION_SIZE Member FunctionGets the operation size for the LOB column in the number of characters for CLOB columns and the number of bytes for BLOB columns. Returns a non- NULL value only if all of the following conditions are met: The value exists for the column The column value is an out-of-line LOB The command type is LOB ERASE or LOB TRIM The information is DBMS_LCR.LAST_LOB_CHUNK Otherwise, returns NULL. Syntax MEMBER

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

GET_SCN Member FunctionReturns the system change number (SCN) of the LCR. Syntax MEMBER FUNCTION GET_SCN RETURN NUMBER;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

SET_OBJECT_TYPE Member ProcedureSets the object type. Syntax MEMBER PROCEDURE SET_OBJECT_TYPE( object_type IN VARCHAR2); Parameter Table 108-9 SET_OBJECT_TYPE Procedure Parameter Parameter Description object_type The object type. The following are valid object types: CLUSTER FUNCTION INDEX LINK OUTLINE PACKAGE PACKAGE BODY PROCEDURE SEQUENCE SYNONYM TABLE TRIGGER TYPE USER VIEW LINK represents a database link. NULL is also a valid

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

SET_BASE_TABLE_NAME Member ProcedureSets the base (dependent) table name. Syntax MEMBER PROCEDURE SET_BASE_TABLE_NAME( base_table_name IN VARCHAR2); Parameter Table 108-4 SET_BASE_TABLE_NAME Procedure Parameter Parameter Description base_table_name The name of the base table

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

SET_LOB_INFORMATION Member ProcedureSets LOB information for the column. Syntax MEMBER PROCEDURE SET_LOB_INFORMATION( value_type IN VARCHAR2, column_name IN VARCHAR2, lob_information IN NUMBER); Parameters Table 108-21 SET_LOB_INFORMATION Procedure Parameters Parameter Description value_type The type of value to set for the column, either old or new. Specify old only if lob_information is set to DBMS_LCR.NOT_A_LOB. column_name The name

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

GET_TAG Member FunctionReturns the tag for the LCR. An LCR tag is a binary tag that enables tracking of the LCR. For example, this tag may be used to determine the original source database of the DML or DDL change when apply forwarding is used. See Also: Oracle9i Streams for more information about tags Syntax MEMBER FUNCTION GET_TAG RETURN RAW;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

GET_LOB_INFORMATION Member FunctionGets the LOB information for the column. The return value can be one of the following: DBMS_LCR.NOT_A_LOB CONSTANT NUMBER:= 1; DBMS_LCR.NULL_LOB CONSTANT NUMBER:= 2; DBMS_LCR.INLINE_LOB CONSTANT NUMBER:= 3; DBMS_LCR.EMPTY_LOB CONSTANT NUMBER:= 4; DBMS_LCR.LOB_CHUNK CONSTANT NUMBER:= 5; DBMS_LCR.LAST_LOB_CHUNK CONSTANT NUMBER:= 6; Returns NULL if the specified column does not exist. Syntax MEMBER FUNCTION

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

LCR$_ROW_RECORD Constructor Function Parameterschange record was written to the redo old_values If the DML statement is an UPDATE or a DELETE

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

ADD_COLUMN Member ProcedureAdds the value as old or new, depending on the value type specified, for the column. An error is raised if a value of the same type already exists for the column. To set a column value that already exists, run SET_VALUE. See Also: "SET_VALUE Member Procedure" Syntax MEMBER PROCEDURE ADD_COLUMN( value_type IN VARCHAR2, column_name IN VARCHAR2, column_value IN SYS.AnyData); Parameters Table 108-12 ADD_COLUMN

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

LCR$_DDL_RECORD ConstructorCreates a SYS.LCR$_DDL_RECORD object with the specified information. STATIC FUNCTION CONSTRUCT( source_database_name IN VARCHAR2, command_type IN VARCHAR2, object_owner IN VARCHAR2, object_name IN VARCHAR2, object_type IN VARCHAR2, ddl_text IN CLOB, logon_user IN VARCHAR2, current_schema IN VARCHAR2, base_table_owner IN VARCHAR2, base_table_name IN VARCHAR2, tag IN RAW DEFAULT NULL, transaction_id

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

GET_DDL_TEXT Member ProcedureGets the DDL text in a CLOB. The following is an example of a PL/SQL procedure that uses this procedure to get the DDL text in a DDL LCR: CREATE OR REPLACE PROCEDURE ddl_in_lcr (ddl_lcr in SYS.LCR$_DDL_RECORD) IS ddl_text CLOB; BEGIN DBMS_OUTPUT.PUT_LINE( ' -----------------------------------------' ); DBMS_OUTPUT.PUT_LINE( ' Displaying DDL text in a DDL LCR: ' ); DBMS_OUTPUT.PUT_LINE( ' -----------------------------------------'

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

LCR$_DDL_RECORD TypeThis type represents a DDL change to a database object. If you create or modify a DDL LCR, then make sure the ddl_text is consistent with the base_table_name, base_table_owner, object_type, object_owner, object_name, and command_type attributes. Note: When passing a name as a parameter to an LCR constructor, you can enclose the name in double quotes to handle names that use mixed case or lower case

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

GET_CURRENT_SCHEMA Member FunctionReturns the current schema name. Syntax MEMBER FUNCTION GET_CURRENT_SCHEMA RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

IS_NULL_TAG Member FunctionReturns Y if the tag for the LCR is NULL, or returns N if the tag for the LCR is not NULL. See Also: Oracle9i Streams for more information about tags Syntax MEMBER FUNCTION IS_NULL_TAG RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

GET_SOURCE_DATABASE_NAME Member FunctionReturns the global name of the source database name. The source database is the database where the change occurred. Syntax MEMBER FUNCTION GET_SOURCE_DATABASE_NAME RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

SET_OBJECT_OWNER Member ProcedureSets the owner of the object that is changed by the LCR. Syntax MEMBER PROCEDURE SET_OBJECT_OWNER( object_owner IN VARCHAR2); Parameter Table 108-29 SET_OBJECT_OWNER Procedure Parameter Parameter Description object_owner The schema that contains the object

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

GET_OBJECT_OWNER Member FunctionReturns the owner of the object that is changed by the LCR. Syntax MEMBER FUNCTION GET_OBJECT_OWNER RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

LCR$_ROW_RECORD TypeThis type represents a DML change to a row in a table. This type uses the LCR$_ROW_LIST type. If you create or modify a row LCR, then make sure the command_type attribute is consistent with the presence or absence of old column values and the presence or absence of new column values. Note: When passing a name as a parameter to an LCR constructor, you can enclose the name in double quotes to handle

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

EXECUTE Member ProcedureExecutes the DDL LCR under the security domain of the current user. Any apply process handlers that would be run for an LCR are not run when the LCR is applied using this procedure. Note: The EXECUTE member procedure can be invoked only in an apply handler for an apply process. Syntax MEMBER PROCEDURE EXECUTE();