Passing . csv filename as input parameter in concurrent program to CTL file. Hi Gokul. This is a similar scenario I had to solve very recently. Create or replace directory 'XX_DATA_DIR' AS '/home/test'.
Create an External Table to read the file from the directory. Do processing necessary based on business logic usinng PL/SQL.
Let us know if this will resolve the issue, or if you need more information. Vishal Saberwal. ( http: //sabersurge.
If the name of your SQL*Loader control file contains special characters. invoke SQL*Loader without any parameters, as described in Invoking SQL*Loader. The READSIZE parameter is used only when reading data from datafiles. Passing.csv filename as input parameter in concurrent program to CTL file. Pass Parameter In Control File of sql* loader. How to Pass Input Parameters into a Siebel Workflow. Below is my Control file example . Can variables be passed to a SQL*Loader control file via sqlldr command? I need to pass DATE_ID_VALUE,ACCOUNTID. Here's my problem, I have created SQL Loader control file (ctl) to load a file of employees. This loader program is registered in Oracle Applications. What I want is to pass a parameter derived from the profile like the user.
Pass Parameter In Control File of sql* loader. Now if I wanted to declare the parameter in.ctl file so that i will pass the path of.csv every time whenever I am. # First 4 system parameters will be used by Oracle # $1. The SQL*Loader control file is a text file that contains data definition language (DDL) instructions. The OPTIONS clause allows you to specify runtime parameters in the control file, rather than on the command line.