The stored procedure should be used in any well designed database. Oracle database takes it as a database object. Since Oracle 8i, not only the original PL/SQL language can be used in the development of stored procedure, but also Java language can be used. Taking the latest Oracle edition as an example, this paper describes the concept, classification and its advantage of stored procedure, elaborates the developing process of it in detail through some solid examples, analyzes the merits and shortcomings of different developing languages, and puts forward some developing suggestions in the end.%任何一个设计良好的数据库应用程序都应该用到存储过程.Oracle将存储过程作为数据库对象存储在数据库中.从Oracle 8i开始,不仅可以使用原有的PL/SQL开发存储过程,还可以使用Java语言来开发存储过程.以最新的Oracle版本为例,叙述存储程序的概念、分类及其优点,通过实例详细阐述Oracle数椐库存储过程的开发过程,分析不同存储过程开发语言的优缺点,提出开发建议.
展开▼