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 11260 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

Describing Schema Metadata

Describing the Stored ProcedureThe difference between a procedure and a function is that the latter has a return type at position … take default types of objects as arguments. Consider the following procedure: P1 (arg1 emp.sal%type … \"; /* the name of a procedure to be described */ ub4 objp_len = (ub4)strlen((char *)objptr); ub2 … **)0); /* get the describe

SQL*Module for Ada Programmer's Guide, 11g Release 1 (11.1)

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

Database SQL Language Reference, 11g Release 1 (11.1)

DROP PROCEDURE

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

Database SQL Language Reference, 11g Release 1 (11.1)

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 … value. Stored procedures offer advantages in the areas of development, integrity, security

Database SQL Language Reference, 11g Release 1 (11.1)

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

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

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

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

DROP PROCEDURE Statement

DROP PROCEDURE StatementThe DROP PROCEDURE statement drops a standalone stored procedure from the database. Note: Do not … use this statement to remove a procedure that is part of a package. Instead, either drop the entire … package using the DROP PACKAGE Statement, or redefine the package without the procedure using the

Database PL/SQL Language Reference, 11g Release 1 (11.1)

ALTER PROCEDURE Statement

ALTER PROCEDURE StatementThe ALTER PROCEDURE statement explicitly recompiles a standalone stored procedure. Explicit … declaration or definition of an existing procedure. To redeclare or redefine a standalone stored … compilation errors and performance overhead. To recompile a procedure that is part of a package

Database PL/SQL Language Reference, 11g Release 1 (11.1)

CREATE PROCEDURE Statement

CREATE PROCEDURE StatementThe CREATE PROCEDURE statement creates or replaces a standalone stored procedure or a call … specification. A standalone stored procedure is a procedure (a subprogram that performs a specific action … ) that is stored in the database. Note: A standalone stored

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

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

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 1 (11.1)

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*PL/1 Supplement to the Oracle Precompilers Guide, 11g Release 1 (11.1)

Sample Programs

Sample Program 9: Calling a Stored procedure; Sample Program 9: Calling a Stored procedure Before trying the sample program, you must create a … the procedure). It can be called from other -- stored procedures or client application programs … stored procedure to fetch Oracle * data into PL/SQL tables, returns the data in host

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

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

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

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

Unsupported SQL CommandsTransaction Support The.NET stored procedure execution automatically inherits the current … , or rolled back inside a.NET stored procedure. For example, OracleConnection.BeginTransaction is … not allowed for.NET stored procedure. Neither local nor distributed transaction support is available

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

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.

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 1 (11.1)

Writing a Pro*FORTRAN Program

Opening Indirectly through a Stored PL/SQL Procedure, you can open the variable curs by calling the open_emp_cur stored procedure from your Pro*FORTRAN … Consider the following PL/SQL package stored in the database: CREATE PACKAGE demo_cur_pkg AS TYPE … EmpName IS RECORD (name VARCHAR2(10)); TYPE cur_type IS REF CURSOR RETURN EmpName; PROCEDUREPROCEDURE

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

PL/SQL REF CURSOR and OracleRefCursor

Passing a REF CURSOR to a Stored Procedurestored function execution The first bind parameter of a stored procedure execution See Also: Oracle … a Stored Procedure An application can retrieve a REF CURSOR type from a PL/SQL stored procedure or … function and pass it to another stored procedure

Data Provider for .NET Developer's Guide, 11g Release 1 (11.1)

Glossary

stored procedureA stored procedure is a PL/SQL block that Oracle stores in the database and can be executed from an application.

Provider for OLE DB Developer's Guide, 11g Release 1 (11.1)

Glossary

stored procedureA stored procedure is a PL/SQL block that are stored in an Oracle Database and can be called by name from an application.