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 .....

Thanks
Sateesh.