105: SELECT null
106: INTO v_dummy from sys.dual
107: WHERE exists (
108: SELECT 1
109: FROM USER_OBJECTS
110: WHERE OBJECT_NAME = v_new_table
111: );
112: utl_file.put_line(i_file_handle,'--Name conflict.Please first drop '||
113: v_new_table);
334: SELECT null
335: INTO v_dummy
336: FROM sys.dual
337: WHERE exists (SELECT 1
338: FROM USER_OBJECTS
339: WHERE OBJECT_NAME = v_new_table
340: );
341: utl_file.put_line(i_file_handle,'Name conflict. Please first drop '||
342: v_new_table);
570: INTO v_dummy
571: FROM sys.dual
572: WHERE exists (
573: SELECT 1
574: FROM USER_OBJECTS
575: WHERE OBJECT_NAME = v_new_index
576: );
577: utl_file.put_line(i_file_handle,'--Name conflict. Please first drop '||v_new_index);
578: utl_file.fclose(i_file_handle);
1166: select null
1167: into v_dummy
1168: from sys.dual
1169: where exists (select 1
1170: from USER_OBJECTS
1171: where OBJECT_NAME = v_new_index
1172: );
1173: utl_file.put_line(i_file_handle,'Name conflict. Please first drop '||v_new_index);
1174: raise_application_error(-20012, v_new_index||' already exists.');