SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

(crud) stored procedures generator script

user564141Dec 17 2008 — edited Dec 17 2008

Hi,

I am wondering if somebody can help me.
I need an oracle sql script that create a package with stored procedures for the basic CRUD (Create, Read, Update, Delete) operations for each table in my database.

For example:

Table EMP

When the sql script has finished then there is a package created (specification and body) with the name:

EMP_PCK (this is an example)

inside the package the implementation of the following procedures:

- EMP_PCK.emp_sel
- EMP_PCK.emp_upd
- EMP_PCK.emp_insrt
- EMP_PCK.emp_del

I did find a script but that'si for SQL-SERVER 2000 :-(
link: [http://www.sqlbook.com/scripts/AutoGenerateCRUDStoredProcs.txt]

Thanks for your help.

Regards,
John

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2009

Added on Dec 17 2008

4 comments

1,530 views