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


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


Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Error Handling

RAISE_APPLICATION_ERROR Procedurefrom a stored subprogram or method. Typically, you invoke this procedure to raise a user-defined … exception named past_due, assigns the error code -20000 to it, and invokes a stored procedure. The … stored procedure invokes the RAISE_APPLICATION_ERROR procedure with

Database Concepts, 11g Release 2 (11.2)

Glossary

stored procedureA named PL/SQL block or Java program that Oracle Database stores in the database. Applications can call stored procedures by name.

SQL*Module for Ada Programmer's Guide, 11g Release 2 (11.2)

Demonstration Programs

Calling a Stored ProcedureThe sample stored package defined can be used to demonstrate how to call a stored procedure from an … for a package -- that contains the GET_GPA stored procedure. -- Use the WITH INTERFACE clause so that … program \"DEMCALSP.A\", written in the host language, that calls the GET_GPA_IF procedure

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

Describing Schema Metadata

Describing the Stored ProcedureStored Procedure... int i = 0, j = 0; text objptr[] = \"add_job_history\"; /* the name of a … The difference between a procedure and a function is that the latter has a return type at position … can take the default types of objects as arguments. Consider the following procedure: P1 (arg1 … procedure

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

9 PL/SQL TriggersA trigger is like a stored procedure that Oracle Database invokes automatically whenever a

Database SQL Language Reference, 11g Release 2 (11.2)

DROP PROCEDURE

DROP PROCEDUREstatement to remove a standalone stored procedure from the database. Do not use this statement to remove a … complete information on creating, altering, and dropping procedures. Use the DROP PROCEDUREprocedure that is part of a package. Instead, either drop the entire package using the DROP PACKAGE … statement,

Database SQL Language Reference, 11g Release 2 (11.2)

CREATE PROCEDURE

CREATE PROCEDUREthe CREATE PROCEDURE statement to create a standalone stored procedure or a call specification. A … procedure is a group of PL/SQL statements that you can call by name. A call specification (sometimes … return value. Stored procedures offer advantages in the areas of development, integrity, security

Database SQL Language Reference, 11g Release 2 (11.2)

ALTER PROCEDURE

ALTER PROCEDUREthe ALTER PROCEDURE statement to explicitly recompile a standalone stored procedure. Explicit … compilation errors and performance overhead. To recompile a procedure that is part of a package … does not change the declaration or definition of an existing procedure. To redeclare or redefine a

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variables as Subprogram Parametersdepartment_id = 100; END IF; END; END emp_data; / In Example 6-32,the stored procedure opens its … type and a procedure that opens a cursor variable parameter of that type. Example 6-30 Procedure to … RETURN employees%ROWTYPE; PROCEDURE open_emp_cv (emp_cv IN OUT empcurtyp); END emp_data; / CREATE OR

Database PL/SQL Language Reference, 11g Release 2 (11.2)

SERIALLY_REUSABLE Pragma

SERIALLY_REUSABLE Pragmaserver (for example, an OCI call to the database or a stored procedure invocation through a database

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Porting Client Application to .NET Stored Procedure

Porting Client Application to .NET Stored Procedure… NET stored procedure. Column Headings The column heading for this table are: Client application … procedure. Explicit connection: The explicit user connections in a.NET stored procedure. Table 4-1 API … Support Comparison Between Client Application and.NET Stored Procedure

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Introducing .NET Stored Procedure Execution Using ODP.NET

Introducing .NET Stored Procedure Execution Using ODP.NETrestrictions exist when Oracle Data Provider for.NET is used within a.NET stored procedure. These … are discussed in the next section. The following is a simple.NET stored procedure example. using … create.NET Stored procedures Table 4-1, \"API Support Comparison Between Client Application and.NET Stored

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Triggers

Overview of TriggersLike a stored procedure, a trigger is a named PL/SQL unit that is stored in the database and can be … invoked repeatedly. Unlike a stored procedure, you can enable and disable a trigger, but you cannot

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Sample Programs

Sample Program 9: Calling a Stored Procedure9999 CONTINUE END Sample Program 9: Calling a Stored Procedure Before trying the sample program, you … called from other -- stored procedures or client application programs. -- The procedure opens the … procedure named get_employees, which is stored in package calldemo. The procedure

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Embedded PL/SQL

Sample Program 9: Calling a Stored Procedure-- of the procedure). It can be called from other -- stored procedures or client application … department number and then calls a PL/SQL procedure named get_employees, which is stored in package … . ***************************************************************** * Sample Program 9: Calling a Stored

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Oracle User-Defined Type (UDT) Support… UDTs are not supported as parameters to.NET stored procedures.

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Transaction SupportThe.NET stored procedure execution automatically inherits the current transaction on the implicit … stored procedure on a Context connection. However, explicit transaction can be started, committed … , or rolled back inside a.NET stored procedure on a Client connection. For example

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Limitations and Restrictions on ODP.NET Within .NET Stored ProcedureThis section covers important concepts that apply when Oracle Data Provider for.NET is used within a.NET stored procedure.

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Unsupported SQL Commandsstored procedure. Data definition commands such as CREATE and ALTER are not supported with an … implicit database connection, but they are supported with an explicit user connection in a.NET stored procedure.

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Implicit Database ConnectionWithin a.NET stored procedure, an implicit database connection is available for use to access … procedure, thereby minimizing resource usage. To obtain an OracleConnection object in a.NET stored … for.NET is used within a.NET stored procedure. Otherwise, false is returned. Note: DBLinks