225: p_view_name IN VARCHAR2,
226: x_return_status OUT NOCOPY VARCHAR2) IS
227: cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)
228: data_precision,NVL(data_scale,0) data_scale 229: FROM user_tab_columns 230: WHERE table_name = UPPER( p_view_name) and (data_type='VARCHAR2' OR data_type='NUMBER');
231: var1 av_csr%rowtype;
232: i number:=1;
233: found Boolean:=FALSE;