What is the best method to declare SP variable ?

Hi all, There is 2 well known way to declare SP input, output or in out argument. Example i have a input argument call NAME which is of VARCHAR2(30) To declare this variable : way 1. NAME IN VARCHAR way 2. NAME IN EMP.NAME%TYPE In term of coding, i know that way 2 is better as if the datatype change you don't have to change the SP code.

But will this impact performace may be during compilation or SP execution compare to way 1?

Or is there are bad point for using way 2?

Hope to hear the answer from you guys soon.

Thank you

Regards, ypc

--
Posted via dBforums
http://dbforums.com