UTL « fopen « C File Q&A

1. Invalid File Operation UTL_FILE.FOPEN    oracle-base.com

Invalid File Operation UTL_FILE.FOPEN by David Thu Jan 29, 2009 6:58 pm I have read several forums to find a solution to my problem with fopen. My dir is set to 'd:\oradmin\DEV1\udump' in the init.ora, I know that is write. Part of the process is to create folders to this dir. I create a folder with the user stamp and ...

2. Utl_File.FOpen    oracle-base.com

Hi. Prior to Oracle9i you actually specified the "real" path and needed the UTL_FILE_DIR parameter to be set. In some versions of Oracle 9i you could use both methods so long as you used the UNIX style slasshes even on windows boxes. I don't think this cheat was supported though, but you might want to try it. The directory object approach ...

3. Utl_file.fopen    dbasupport.com

4. utl_file.fopen    dbasupport.com

Here is the problem with UTL_FILE, mapped network drives and NT ( I belive that this is correct - at least it may point you in the right direction ) During the startup process of the machine, the services are started before any mapped drives are mounted. This will not allow the database to see the location specified by UTL_FILE_DIR ( ...

5. Error fopen utl_file    dbasupport.com

6. Question about UTl_file.FOPEN    dbasupport.com

OK. I've chopped out a lot of the junk and left the good parts. DECLARE ------------------------------- -- Variables for BOL record -- ------------------------------- l_bol_cont_mv_disc VARCHAR2(11); l_bol_pallet_chg VARCHAR2(11); l_bol_misc_chg VARCHAR2(11); l_bol_cancel_truck VARCHAR2(11); l_bol_sfi_out_route_mile VARCHAR2(11); l_bol_return VARCHAR2(11); l_bol_sfi_detent VARCHAR2(11); l_bol_fuel_sur VARCHAR2(11); l_bol_redeliv VARCHAR2(11); l_bol_reconsign VARCHAR2(11); l_bol_cust_out_route_mile VARCHAR2(11); l_bol_cust_detent VARCHAR2(11); l_bol_lmpr_chg VARCHAR2(11); l_bol_unload VARCHAR2(11); l_bol_vouch_amt VARCHAR2(11); l_bol_tot_wgt VARCHAR2(11); l_bol_line_haul NUMBER(13,2); ---------------------------------- -- Variables for ...

7. utl_file.fopen    dbforums.com

8. Utl_file.fopen    dbforums.com

Right, why oh why do Oracle make it so damn difficult to load CSV format files using UTL_FILE..... well I think it is.. never having done it before! Any way IM about half way through and then I hit the column placement bit... could someone please explain to me what this means????? and I quote...' --Use the SUBSTR to extract the ...