Top "Utl-file" questions

UTL_FILE.FOPEN() procedure not accepting path for directory?

I am trying to write in a file stored in c:\ drive named vin1.txt and getting this error .Please …

oracle plsql oracle9i utl-file

Read text file to insert data into Oracle SQL table

I am studying Oracle SQL developer. What I am doing is reading text file line by line from the folder. …

sql oracle11g oracle-sqldeveloper utl-file

ORACLE 11G UTL_FILE + UTL_FILE_DIR - Invalid Directory

Hi I am running Oracle 11 and I am trying to write to a directory on the server box using UTL_…

oracle oracle11g utl-file

How to write to a text file from Pl/SQL, PLS error 00363

I am trying to write to a file from a procedure: out_File := Utl_File.FOpen('C:\test', 'batotest.txt' , …

oracle plsql utl-file

Oracle - Create text file using stored procedure

Need help on creating text file using stored procedure in oracle 10. I'm very new to this so please guide me …

oracle utl-file

What is the recommended way to encrypt in Oracle?

I need some help from Oracle/Security experts. I'm going to make functions for encryption/decryption in our Oracle DB. …

database oracle security cryptography utl-file

Delete file from server using UTL_FILE.FRemove without knowing the file name

I am a reporting analyst, who was asked to learn some PL/SQL to automate some processes. So I am …

oracle stored-procedures plsql wildcard utl-file

how do I read a local file in SQL Developer?

I want to read a file on my local machine that contains query parameters when I execute a query in …

oracle input plsql oracle-sqldeveloper utl-file

Pl SQL reading text file from directory on database

I have to read a text file that I have created on the database. I am not sure what the …

oracle plsql oracle11g utl-file

Invalid Directory path while executing a procedure that produces a csv file in Oracle (in windows)

I have a procedure create or replace procedure dump_table_to_csv( p_tname in varchar2, 2 p_dir in varchar2, 3 …

oracle csv plsql utl-file