Oracle Apps Technical Stuff
Showing posts with label
UTL File
.
Show all posts
Showing posts with label
UTL File
.
Show all posts
Monday, March 17, 2014
How To Write Out Multiple Clob Fields > 32k To A File in 4K chunks? (Doc ID 358781.1)
›
DECLARE l_output UTL_FILE.file_type; l_amt NUMBER DEFAULT 4000; l_offset NUMBER DEFAULT 1; position INTEGER := 1; contado...
Thursday, January 9, 2014
PLSQL Script to load the data from Flat file into Oracle Table dynamically
›
1. create below log table to capture the error records details . CREATE TABLE XX_BAD_DATA_LOG_TBL ( FILE_NAME VA...
Friday, September 20, 2013
How to Copy Any File using UTL_FILE
›
While UTL_FILE.FCOPY can be used to copy valid text files, it does not copy binary files or invalid text files. An example of an invalid t...
2 comments:
Thursday, August 23, 2012
Script To Check the File On Database Server(Unix) Using UTL_FILE
›
Below Script is used to verify the file exists on the Server using PLSQL UTL_FILE functionality. DECLARE l_fexists BOOLEAN; ...
›
Home
View web version