how to execute stored procedure in oracle

What is a stored procedure. is a collection of SQL that can be manipulated programmatically. the advantages of stored procedures. execution is efficient because the stored procedure is precompiled, that is, when the compile is created, and the SQL statement is executed once, compiled once. Invoking a stored procedure can significantly reduce the number of inte

storage object. is also the default permission mode. Authid current_user (caller permissions): A pattern that has the current session permission, which may be the same as or different from the current logged-on user (alter session set CURRENT_SCHEMA can change the caller schema) When you create a stored procedure in a database, the definition user permission is the default mode. When the authid current_user keyword is specified, it is the caller's pe

1. Create a stored procedure Create or Replace procedure test (var_name_1 in type,var_name_2 out type) as--Declaring variables (variable name variable type)Begin--The execution body of the stored procedureEnd test;Print out the time information enterede.g:Create or Replace procedure test (workdate in Date) isBeginDbms_output.putline (' The input date is: ' | | To

1. First create the package with PL/SQL1 Create or ReplacePackage Excutebatchoperate2 as3Type Sqlstr_array is Table of varchar2( +)Index byBinary_integer;4 procedureExcutebulkdata (sqlstrinchSqlstr_array);5 EndExcutebatchoperate;2. Create a stored procedure within Packagebody1 Create or ReplacePackage Body Excutebatchoperate2 as3 procedureExcutebulkdata (sqlstrinchSqlstr_array)4 as5 begin6 forIinch 1.. Sqlstr.CountLoop7 Executei

Transferred from: http://lorry1113.javaeye.com/blog/513851Keywords: Oracle stored procedures1. Basic structure CREATE OR REPLACE PROCEDURE stored procedure name (parameter 1 in number, parameter 2 in number) is variable 1 INTEGER: = 0; Variable 2 DATE; BEGINEND Stored Procedure Name2.SELECT into STATEMENT the results o

Last_ddl_time ------------------------------ ------------------- Pining 2007-03-31 17:54:35 In oracle10g, this last_ddl_time no longer changes, which means that in 10g, when we execute the Create or replace PROCEDURE, Oracle now tries the process check, and if the content doesn't change, You do not need to recompile the process, which reduces the invalidation

; Similar to the return value in Java --Understanding in-out parameters PROCEDURE Hello1 (out emp.ename%type ) --SELECT emp.ename to p_name from EMP; p_name:= END; ------------------------------------------------------------------------BEGIN v_nanme:=' 12312 '; hello1 (V_nanme); Add: Execute stored procedure with output parameter as curs

error, hintOra-01422:exact fetch returns more than requested number of ROWS5. In the stored procedure, the issue of NULL occursSuppose there is a table A, which is defined as follows:CREATE TABLE A (ID VARCHAR2 (primary) key NOT NULL,Vcount Number (8) is not NULL,Bid varchar2 () NOT null--foreign key); If you are in a stored procedure, use the following statement:Select SUM (vcount) into Fcount from A wher

Tags: style blog http color io os using AR javaTransferred from: http://lorry1113.javaeye.com/blog/513851Keywords: Oracle stored procedures1. Basic structure CREATE OR REPLACE PROCEDURE stored procedure name (parameter 1 in number, parameter 2 in number) is variable 1 INTEGER: = 0; Variable 2 DATE; BEGINEND Stored Procedure