PROCEDURE create_user_list
IS
BEGIN
   HTP.p('<SELECT NAME="T_USRS" disabled>');
   HTP.p('<OPTION value="'||user||'">'||user||'</OPTION>');
   HTP.p('</SELECT>');
   HTP.br;
   HTP.br;
END create_user_list;

PROCEDURE get_def (obj_type IN VARCHAR2,
                   obj_name IN VARCHAR2)
IS
   v_script VARCHAR2(32000);
BEGIN
   IF ((obj_type IS NULL) OR (obj_name IS NULL)) THEN
       HTP.p('please fill desired parameters..!');
   ELSE
       v_script:= DBMS_METADATA.GET_DDL(obj_type,obj_name,user);
       HTP.p('<pre>'||v_script||'</pre>');
   END IF;
   HTP.anchor('javascript:history.go(-1)','Back');
END get_def;