| Data is not importing to table through SQL Loader when run through Forms [message #447838] |
Thu, 18 March 2010 03:50  |
m.bhatkrishna@gmail.com
Messages: 6
Registered: September 2009
|
Junior Member |
|
|
Hi all,
I have to load .csv file contents to table . I a m using Oracle Forms 10g, I have kept .csv file and .ctl file in application server c:\ DIRECTORY. In Form i have called host command to execute the batch file . But data is not loading as well as no error.
Even i have batch file also in Application Server C:\ path .
Code i have used in Form is
HOST('C:\TEST.BAT');
contents of the batch file are
C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlldr.exe csd/a@iismig control=c:\GL2009_TEST.ctl bad=C:\GL2009_TEST.bad skip=1 log=c:\gl2009_test.log
contents of the .ctl file is
LOAD DATA
INFILE 'C:\GL2009.CSV'
REPLACE
INTO TABLE F_GL_SMRY_TEMP
FIELDS TERMINATED BY ","
(ref_id,tran_date,dr_amt,cr_amt,acct_code,sub_code,cctr_code,sundry_code,dept_code)
if i run test.bat in manual mode without Forms Application .. it works fine with no error. sqlloader is installed in application server .
Please give suggestions...
Regards,
Krishna
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
