Hi,

In Pro*C, while declaring host variables, can we declare size of the variable same as that of the column of Oracle tabel.

It means if i am decalring size as below:

VARCHAR username[20];

where actually i want to keep the size same as that of the USER_ID field of oracle table.


can we use something like %TYPE or %ROWTYPE?

Pl. reply