This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2009 International Forum on Information Technology and Applications
Design and Implementation of Stored Procedure Router Based on Dynamic SQL
Chengdu, China
May 15-May 17
ISBN: 978-0-7695-3600-2
The stored procedure router is designed to dynamically call stored procedure. It is based on dynamic SQL and coded by PL/SQL. Two tables are established according to stored procedure table and stored procedure parameter table before stored procedure router is called. The caller gets input and output parameters of stored procedure by visiting two tables, without direct contact stored procedure itself. Inputting stored procedure number and parameters can obtain result of executing stored procedure. Dynamic SQL statement based on these parameters is designed and executed. Input parameters and output parameters are bind the corresponding variables which begin to the colon in SQL statement.When invoking stored procedure coded by PL/SQL, it is convenient to use stored procedure router. Only modify content of table when stored procedure changes. It brings a great facilitate to secondary development staff and accelerate the system design process, improve the system design performance.
Index Terms:
Stored Procedure, Dynamic SQL, PL/SQL
Citation:
Teng Yingyan, He Zonggang, "Design and Implementation of Stored Procedure Router Based on Dynamic SQL," ifita, vol. 3, pp.476-478, 2009 International Forum on Information Technology and Applications, 2009
Usage of this product signifies your acceptance of the Terms of Use.