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 PROCEDURE


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


Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Triggers and Stored Procedures

ProcedureThis section provides the following tables for the schema object Procedure: Create Drop Execute … Alter Create Table 3-2 Comparison of Creating the Procedure Schema Object in Oracle and Microsoft SQL … : CREATE PROCEDURE procedure [@formal_ parameter formal_parameter_data type [OUTPUT] [= default_value … ] procedural_statements

Objects for OLE, 9i Release 2 (9.2.0.2)

CommitGrid_Click() Procedure

CommitGrid_Click() ProcedureFeedback CommitGrid_Click() Procedure The cmdCommitGrid_Click() procedure looks like: Private Sub

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

DBMS_RESOURCE_MANAGER_PRIVS, 2 of 2

REVOKE_SYSTEM_PRIVILEGE ProcedureThis procedure performs a revoke of a system privilege from a user or role.

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

DBMS_RESOURCE_MANAGER_PRIVS, 2 of 2

GRANT_SWITCH_CONSUMER_GROUP ProcedureThis procedure grants the privilege to switch to a resource consumer group.

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

DBMS_REPCAT, 2 of 2

COMMENT_ON_MVIEW_REPSITES ProcedureThis procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP data dictionary view for the … materialized view group. This procedure must be executed at the materialized view site.

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

DBMS_CAPTURE_ADM, 2 of 2

PREPARE_TABLE_INSTANTIATION Procedureprocedure at the source database. This procedure records the lowest SCN of the table for instantiation

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

DBMS_FLASHBACK, 2 of 2

DISABLE ProcedureThis procedure disables the Flashback mode for the entire session.

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

DBMS_RLS, 2 of 2

ENABLE__GROUPED_POLICY ProcedureThis procedure enables or disables a row-level group security policy.

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

DBMS_RULE_ADM, 2 of 2

GRANT_OBJECT_PRIVILEGE Procedureoption. To run this procedure, a user must meet at least one of the following requirements: Be the

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

UTL_HTTP, 2 of 2

GET_PERSISTENT_CONN_SUPPORT ProcedureThis procedure checks: If the persistent connection support is enabled Gets the maximum number of persistent connections in the current session

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

UTL_HTTP, 2 of 2

SET_BODY_CHARSET ProcedureThis procedure sets the character set of the response body when the media type is "text" but the … default to "ISO-8859-1". Use this procedure to change the default body character set a response inherits from the request.

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

DBMS_LOGSTDBY, 2 of 2

APPLY_SET ProcedureUse this procedure to set and modify the values of initialization parameters that configure and … manage log apply services in a logical standby database environment. Log apply services cannot be running when you use this procedure.

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

DBMS_WM, 2 of 2

CommitResolve ProcedureEnds a conflict resolution session and saves (makes permanent) any changes in the workspace since the BeginResolve Procedure was executed.

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

DBMS_WM, 2 of 2

RecoverAllMigratingTables Procedureafter the Workspace Manager migration procedure failed.

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

DBMS_METADATA, 2 of 2

SET_FILTER ProcedureSET_FILTER specifies restrictions on the objects to be retrieved, for example, the object name or schema.

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

DBMS_RANDOM, 2 of 2

TERMINATE ProcedureWhen you are finished with the package, call the TERMINATE procedure.

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

DBMS_MVIEW, 2 of 2

PURGE_DIRECT_LOAD_LOG ProcedureThis procedure removes entries from the direct loader log after they are no longer needed for any … known materialized view. This procedure usually is used in environments using Oracle's data

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_AW_CREATE, 8 of 15

AW_CUBE_CREATE ProcedureThis procedure creates the containers within an analytic workspace to hold an OLAP Catalog cube

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT

DROP_MASTER_REPGROUP ProcedureThis procedure drops a master group from your current site. To drop the master group from all … master sites, including the master definition site, you can call this procedure at the master definition site, and set all_sites to true.

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

DBMS_AQADM, 2 of 2

CREATE_QUEUE ProcedureThis procedure creates a queue in the specified queue table.

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

DBMS_AQADM, 2 of 2

GRANT_QUEUE_PRIVILEGE ProcedureThis procedure grants privileges on a queue to users and roles. The privileges are ENQUEUE or … DEQUEUE. Initially, only the queue table owner can use this procedure to grant privileges on the queues.

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM_CLASSIFY, 9 of 19

CREATE_DESCRIPTOR_TYPE ProcedureThis procedure creates a descriptor type. A descriptor type serves as a domain for descriptors … which its descriptors may apply. This procedure is only available to DBAs.

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_AW_CREATE, 9 of 15

AW_CUBE_DEFINE_LOAD ProcedureThis procedure creates a load definition for an OLAP Catalog cube. The load definition specifies

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_AW_CREATE, 6 of 15

AW_DIMENSION_REFRESH ProcedureThis procedure uses a load definition to load values from dimension tables into an analytic

OLAP User's Guide, 9i Release 2 (9.2.0.2)

OLAP_API_SESSION_INIT, 6 of 7

CLEAN_ALTER_SESSION ProcedureContents Index Master Index Feedback View PDF CLEAN_ALTER_SESSION Procedure This procedure removes

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_METADATA_REFRESH, 4 of 4

MR_REFRESH ProcedureThis procedure refreshes the metadata tables that underlie the MRV_OLAP views, as described in "The … creates, drops, or updates OLAP Catalog metadata for the OLAP API. The MR_REFRESH procedure includes a

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT

COMMENT_ON_REPSITES ProcedureIf the replication group is a master group, then this procedure updates the MASTER_COMMENT field in … , this procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP view for a materialized view site … . This procedure can be executed at either a master site or a materialized view site. If you execute … this procedure

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_OFFLINE_OG

BEGIN_LOAD ProcedureThis procedure disables triggers while data is imported to the new master site as part of offline … instantiation. You must call this procedure from the new master site. Note: This procedure is used to … procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT_RGT

DROP_ALL_TEMPLATE_SITES ProcedureThis procedure removes all entries from the DBA_REPCAT_TEMPLATE_SITES view, which keeps a record of … sites that have instantiated a particular deployment template. Caution: This is a dangerous procedure that cannot be undone.

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

UTL_HTTP, 2 of 2

GET_TRANSFER_TIMEOUT ProcedureThis procedure retrieves the default timeout value for all future HTTP requests.

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

DBMS_METADATA, 2 of 2

ADD_TRANSFORM ProcedureADD_TRANSFORM specifies a transform that FETCH_xxx applies to the XML representation of the retrieved objects. It is possible to add more than one transform.

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

DBMS_REPAIR, 2 of 2

SEGMENT_FIX_STATUS ProcedureWith this procedure you can fix the corrupted state of a bitmap entry. The procedure either

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

DBMS_LOB, 2 of 2

FILECLOSE ProcedureThis procedure closes a BFILE that has already been opened through the input locator. Note: Oracle

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

DBMS_MVIEW, 2 of 2

BEGIN_TABLE_REORGANIZATION ProcedureThis procedure performs a process to preserve materialized view data needed for refresh. It must be called before a master table is reorganized.

Concepts, 9i Release 2 (9.2.0.2)

Privileges, Roles, and Security Policies

Procedure Securitywell as packages, is EXECUTE. Grant this privilege only to users who need to execute a procedure or … compile another procedure that calls it. Procedure Execution and Security Domains A user with the … EXECUTE object privilege for a specific procedure can execute the procedure or compile a program unit

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT_ADMIN

REGISTER_USER_REPGROUP ProcedureThis procedure assigns proxy materialized view administrator or receiver privileges at the master … site or master materialized view site for use with remote sites. This procedure grants only the

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_AW_CREATE, 3 of 15

AW_DIMENSION_CREATE ProcedureThis procedure creates the containers within an analytic workspace to hold an OLAP Catalog

OLAP User's Guide, 9i Release 2 (9.2.0.2)

CWM2_OLAP_TABLE_MAP, 13 of 19

REMOVEMAP_DIMTBL_HIERSORTKEY ProcedureThis procedure removes custom sorting criteria associated with columns in a dimension table.

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

DBMS_APPLY_ADM, 2 of 2

SET_SCHEMA_INSTANTIATION_SCN Procedure… This procedure overwrites any existing instantiation SCN for the particular schema. This procedure … , the apply process applies the DDL LCR. The instantiation SCN specified by this procedure is used on … instantiation SCN set by this procedure is used for a DDL LCR with a command_type of CREATE TABLE and

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

DBMS_RULE_ADM, 2 of 2

DROP_RULE ProcedureDrops a rule. To run this procedure, a user must meet at least one of the following requirements … set without dropping the rule from the database, use the REMOVE_RULE procedure. The rule evaluation … context associated with the rule, if any, is not dropped when you run this procedure.

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

DBMS_DEBUG, 2 of 2

ATTACH_SESSION ProcedureThis procedure notifies the debug session about the target program.

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

DBMS_AQADM, 2 of 2

CREATE_QUEUE_TABLE ProcedureThis procedure creates a queue table for messages of a predefined type. The sort keys for dequeue

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

DBMS_TRANSACTION, 2 of 2

COMMIT_FORCE ProcedureThis procedure is equivalent to following SQL statement: COMMIT FORCE, "

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

DBMS_RLS, 2 of 2

ADD_GROUPED_POLICY ProcedureThis procedure adds a policy associated with a policy group.

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

UTL_TCP, 2 of 2

flush ProcedureThis procedure transmits all data in the output buffer, if a buffer is used, to the server immediately.

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

UTL_HTTP, 2 of 2

READ_TEXT ProcedureThis procedure reads the HTTP response body in text form and returns the output in the caller

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

DBMS_OUTLN_EDIT, 2 of 2

DROP_EDIT_TABLES ProcedureThis procedure drops outline editing tables in calling the user's schema.

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

DBMS_WM, 2 of 2

SetWoOverwriteON ProcedureEnables the VIEW_WO_OVERWRITE history option that had been disabled by the SetWoOverwriteOFF Procedure.

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

DBMS_METADATA, 2 of 2

SET_PARSE_ITEM ProcedureSET_PARSE_ITEM enables output parsing by specifying an object attribute to be parsed and returned. It should only be used in conjunction with FETCH_DDL.

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

DBMS_DISTRIBUTED_TRUST_ADMIN, 2 of 2

ALLOW_ALL ProcedureThis procedure empties the Trusted Servers List and specifies that all servers that are members of

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

DBMS_REDEFINITION, 3 of 3

START_REDEF_TABLE ProcedureThis procedure initiates the redefinition process. After verifying that the table can be redefined

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

DBMS_STATS, 2 of 2

CONVERT_RAW_VALUE ProcedureThis procedure converts the internal representation of a minimum or maximum value into a datatype

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

DBMS_STATS, 2 of 2

EXPORT_DATABASE_STATS ProcedureThis procedure retrieves statistics for all objects in the database and stores them in the user stat tables identified by statown. stattab

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

DBMS_REPCAT_RGT, 2 of 2

ALTER_REFRESH_TEMPLATE ProcedureThis procedure allows the DBA to alter existing deployment templates. Alterations may include

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

DBMS_DEFER_SYS, 2 of 2

CLEAR_PROP_STATISTICS ProcedureThis procedure clears the propagation statistics in the DEFSCHEDULE data dictionary view. When this … procedure is executed successfully, all statistics in this view are returned to zero and statistic … gathering starts fresh. Specifically, this procedure clears statistics from the following columns in

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

DBMS_MVIEW, 2 of 2

REFRESH ProcedureThis procedure refreshes a list of materialized views.

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

DBMS_REPCAT, 2 of 2

COMMENT_ON_REPGROUP ProcedureThis procedure updates the comment field in the DBA_REPGROUP view for a master group. This procedure must be issued at the master definition site.

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

DBMS_REPCAT, 2 of 2

PURGE_MASTER_LOG ProcedureThis procedure removes local messages in the DBA_REPCATLOG view associated with a specified

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT_RGT

DROP_ALL_OBJECTS ProcedureThis procedure allows the DBA to drop all objects or specific object types from a deployment … template. Caution: This is a dangerous procedure that cannot be undone.

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

DBMS_REPCAT, 2 of 2

ADD_SITE_PRIORITY_SITE ProcedureThis procedure adds a new site to a site priority group. You must call this procedure from the