Hi all,

The input parameter declaration in postgres8.4 version is

iv_empname employee.empname%type

but in 9.1 version this automatically converted to

iv_empname character varying(200)

The main purpose of declaration like iv_empname employee.empname%type is ,in future we change the data type automatically it will pick the correct datatype without changing.

How can we do in postgres9.1 version?

Please help us .....