Oracle 存储过程　　1

Oracle存储过程基础知识　　1

Oracle存储过程的基本语法　　2

关于Oracle存储过程的若干问题备忘　　4

1.　　在Oracle中，数据表别名不能加as。　　4

2.　　在存储过程中，select某一字段时，后面必须紧跟into，如果select整个记录，利用游标的话就另当别论了。　　5

3.　　在利用select...into...语法时，必须先确保数据库中有该条记录，否则会报出 no data found 异常。　　5

4.　　在存储过程中，别名不能和字段名称相同，否则虽然编译可以通过，但在运行阶段会报错　　5

5.　　在存储过程中，关于出现null的问题　　5

6.　　Hibernate调用Oracle存储过程　　6

用Java调用Oracle存储过程总结　　6

一、　　无返回值的存储过程　　6

二、　　有返回值的存储过程（非列表）　　8

三、　　返回列表　　9

在存储过程中做简单动态查询　　11

一、　　本地动态SQL　　12

二、　　使用DBMS_SQL包　　13

Oracle存储过程调用Java方法　　16

Oracle高效分页存储过程实例　　17-

The Oracle stored procedure 1



Basic knowledge of Oracle stored procedure 1



2 the Oracle stored procedure of the basic grammar



Several problems about the Oracle stored procedure memo 4



1. In Oracle, alias added as data table. 4



2. In the process of storage,　a field, must follow into behind, if　the entire record, using a cursor is another matter. 5



3. In the use of the select... Into... Grammar, have to ensure that the　has a record of this, or you will quote us \ no data found\　exception. 5



4. In the process of storage, alias not same with the field name, otherwise while compiling can pass, but an error in the operation phase 5



5. In the process of storage, null problem about 5



6. Hibernate calls the Oracle stored procedure 6



With Java calls the Oracle stored procedure summarizes six



A stored procedure 6, no return value



Second, returns a value of the stored procedure (not list) 8



Three, the returned list



In the process of sto