Shulou(Shulou.com)06/01 Report--

1. Stored procedure structure 1.1.The first stored procedure create or replace procedure proc1 (p_para1 varchar2, p_para2 out varchar2, p_para3 in out varchar2) as v_name varchar2 (20); begin v_name: = 'Zhang Sanfeng'; p_para3: = vsigename; dbms_output.put_line ('pairpara3p_para2 out varchar2' | | p_para3); above end;/* is the simplest stored procedure. A stored procedure is roughly divided into several parts: create statement: create or replace procedure stored procedure name if there is no or replace statement, it is just a new stored procedure. If the stored procedure exists on the system, an error will be reported. Create or replace procedure if there is no such stored procedure in the system, create a new one, delete the original stored procedure if there is such a stored procedure in the system, and recreate a stored procedure. Stored procedure name definition: includes the stored procedure name and parameter list. Parameter name and parameter type. The parameter name cannot be repeated. The parameter transfer method: IN, OUT, and IN OUT IN represent input parameters, and are passed by value. OUT represents the output parameter, which can be understood as passing by reference. Can be used as the output of a stored procedure for use by external callers. IN OUT can be used as input parameter as well as output parameter. The data type of the parameter only needs to specify the type name, not the width. The width of the parameter is determined by the external caller. Procedures can have parameters or no parameter variable declaration blocks: the as (is) keyword that follows can be understood as the declare keyword of pl/sql, which is used to declare variables. The variable declaration block is used to declare the variables that the stored procedure needs to use, and its scope is the stored procedure. In addition, the variable declared here must specify the width. Follow PL/SQL 's variable declaration specification. Procedure statement block: a statement block that is a procedure starting with the begin keyword. The specific logic of the stored procedure is implemented here. Exception handling block: the keyword is exception to handle the exception generated by the statement. This section is an optional closing block: as a result of the end keyword. , /

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.