Stack Overflow
Stack Overflow

Questions tagged [utl-file]

An Oracle package to enable reading and writing of text files on the operating system.

utl_file is an Oracle package that offers a limited version of standard operating system file I/O to read and write text files outside of the database.

Access to files is possible through a directory object but is also restricted by any operating system privileges.

Questions tagged should also be tagged .

Further reading:

164 questions
1
vote
1 answer

Generate .txt file and insert it into an oracle table pl / sql

I have a procedure that receives the contents of a file in a single variable and I divide it into lines and divide the fields of each line delimited by commas, all that process I do it correctly but now I must generate a new file with some specific…
Cesar Tepetla
  • 39
  • 1
  • 8
1
vote
1 answer

How to import data from large CSV file(file is bigger then 32767) to database using UTL_FILE

I have a csv file with 90000 records, when I am trying to import the csv in database I am getting below error- Error report - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "AUTOLOCK.TEST_C1", line…
Akhil Sharma
  • 11
  • 2
1
vote
3 answers

Trying to write output to a CSV on a directory, failing with PLS-00302

I'm attempting to output some monitoring information into a .csv file. I have to stick with the "Basic" framework of the code. The issue is getting it to output to .csv/getting the code to compile. I've tried various ways of doing this, now I'm…
Scouse_Bob
  • 600
  • 7
  • 26
1
vote
0 answers

ORA-29285: file write error

I'm trying to extract data from an Oracle table. I'm using utl file for that and I'm receiving the error ORA-29285: file write error. The weird here is if I try extract the data directly from the table return the error, if I extract the data using a…
Priscila Ferreira
  • 21
  • 1
1
vote
3 answers

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 p_filename in varchar2 ) 4 is 5…
Yahoo-Me
  • 4,933
  • 5
  • 27
  • 26
1
vote
1 answer

Oracle APEX - grabbing script output

Does APEX make it possible to call a script using dbms_scheduler, utl_file or other and grab it's output? The goal is to pass a command to an external API and show a popup either if an exception is generated or a sucess message is received. Thanks
Joao Figueiredo
  • 3,120
  • 3
  • 31
  • 40
1
vote
1 answer

Special Character not repeated not twice in Oracle

I have a column Value Méroné in my Oracle DB. We are writing it to a csv file using utl_file package.Since this value has a special character we have used convert function to change the character coding to remove the junk character while writing.…
Pranav Mohan
  • 23
  • 3
1
vote
1 answer

How to generate .csv file from oracle table data?

I have generated a csv file using the below query, but all column data are coming in one column in the csv file. Please help me to separate these column data. create or replace procedure csv_generate as CURSOR c1 is SELECT * FROM emp; v1…
Alok
  • 61
  • 1
  • 8
1
vote
1 answer

pl/sql join two files and read them

I need to join multiple files into a single one to read it from my external table Since these files are named 'randomly' (anyway I can find a pattern) for example: ADG_LOZX723536.txt ADG_LOZX142596.txt I have a pkg that executes operations reading…
Mike John
  • 75
  • 2
  • 8
1
vote
1 answer

Extracting from Database BLOB Gets Slower

We have been running a stored procedure to extract BLOBS from a database every day for roughly the last 5 years. We generally extract around 25 files each night, with the majority being approximately 500KB in size and a handful nearing 10,000KB.…
hshah
  • 842
  • 4
  • 14
  • 35
1
vote
1 answer

Ora-29283 error on 11g

Is it possible to access a folder on my PC from oracle database? In other words database is not installed on my local machine and I have created a folder on my PC 'C:\LOB' where I want to save images retrieved from database, but it is returning an…
Mlle 116
  • 1,149
  • 4
  • 20
  • 53
1
vote
1 answer

How to create zip folder in plsql (Oracle)

I am creating a file in a directory which i am specifying. I want for each run a different folder name is created in a directory with different file name. And this folder should be zipped. Currently I am using : create or replace PROCEDURE…
sreekem bose
  • 451
  • 3
  • 12
  • 28
1
vote
2 answers

How to write into a file apart from UTL_FILE

I have written a program to write a file into a directory using utl_file. sample script : PROCEDURE XX_FILE_TRANS (X_RETCODE VARCHAR2,X_ERRBUF VARCHAR2) IS CURSOR ORG_CUR…
sreekem bose
  • 451
  • 3
  • 12
  • 28
1
vote
1 answer

I created CSV file using UTL_FILE in Oracle. How do I read it back?

I wrote a procedure to extract view contents to a file system in Oracle. Now client want's to test the contents of the file. How do I do it in generic way in Oracle? Procedure: CREATE OR REPLACE PROCEDURE PRC_EXTRACT_VIEW (p_view_name VARCHAR2,…
user6356984
1
vote
1 answer

PL/SQL: numeric or value error in UTL_COMPRESS

This code works fine when compressing small files (4M), but I get numeric or value error when trying to compress large files (1.3G). Any idea what I am missing here? The piped line function ListDir is working correctly, so that is not the…
Stringer
  • 188
  • 8
1 2
3
…
10 11