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
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
Describing the Stored Procedure → Stored 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
DROP PROCEDURE → statement 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 PROCEDURE … procedure that is part of a package. Instead, either drop the entire package using the DROP PACKAGE … statement,
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 … return 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
stored procedure → A named PL/SQL block or Java program that Oracle Database stores in the database. Applications can call stored procedures by name.
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
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
RAISE_APPLICATION_ERROR Procedure → from 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
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 → -- 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
Oracle User-Defined Type (UDT) Support → … UDTs are not supported as parameters to.NET stored procedures.
Transaction Support → The.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
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.
Unsupported SQL Commands → stored 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.
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
Passing a REF CURSOR to 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 or function. This feature is useful in scenarios where a stored … logic, the application passes this REF CURSOR to another 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
stored procedure → A stored procedure is a PL/SQL block that Oracle stores in the database and can be executed from an application.