How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Describing the Stored Procedure → The 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
Calling a Stored Procedure → The 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
DROP PROCEDURE → statement 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
CREATE PROCEDURE → the 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
ALTER PROCEDURE → the 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
Introducing .NET Stored Procedure Execution Using ODP.NET → restrictions 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
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
DROP PROCEDURE Statement → The 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
ALTER PROCEDURE Statement → The 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
CREATE PROCEDURE Statement → The 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
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
Sample Program 9: Calling a Stored Procedure → 9999 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
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
Implicit Database Connection → Within 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
Unsupported SQL Commands → Transaction 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
Limitations and Restrictions on ODP.NET Within .NET Stored Procedure → This section covers important concepts that apply when Oracle Data Provider for.NET is used within a.NET stored procedure.
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; PROCEDURE … PROCEDURE
Passing a REF CURSOR to a Stored Procedure → stored 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
stored procedure → A stored procedure is a PL/SQL block that Oracle stores in the database and can be executed from an application.