DBA Data[Home] [Help]

APPS.WSH_UTILITIES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

   select INSTR(value,',',1,2),INSTR(value,',',1,3)
   into v_st_position,v_end_position from  v$parameter
   where upper(name) = 'UTL_FILE_DIR';
Line: 43

   select substr(value,v_st_position+1,v_w_position)
   into v_log_name from v$parameter
   where upper(name) = 'UTL_FILE_DIR';