A procedure is similar to a package in the way that it also allows you to define a sequence of codes. You can add multiple “commands” to a procedure and the command will be executed in sequence. A command contains the code that can be executed by database engine, the operating system, or by ODI itself. Unlike a package, a procedure is designed to be reused. You can parameterize a procedure by providing options.
A procedure can be added into a package in a similar way to adding an interface into a package. Like an interface, a procedure is referenced by a package, instead of making a copy. If you change the procedure, all package referencing it will be changed.
You can create procedure by including the Sunopsis tool, such as sending email to the administrator. It can parameterize the sending email tool so it can be reused.
특징 :
* parameter들을 이용해서 호출 가능
* be designed to be reused.
* package에 interface와 같은 방식인 Drag & Drop 으로 사용 가능
* procedure는 copy가 아닌 reference 방식으로 사용되므로 프로시저 수정이 발생할 경우 해당 프로시져를 참조하는 모든 패키지 역시 영향을 받는다.
