Home » Developer & Programmer » Forms » Data is not importing to table through SQL Loader when run through Forms (Oracle Forms 10g, Oracle Database 9i, Application Server 10g rel 2, sqlloader 10.2.0.1.0)
Data is not importing to table through SQL Loader when run through Forms [message #447838] Thu, 18 March 2010 03:50 Go to next message
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
Re: Data is not importing to table through SQL Loader when run through Forms [message #447847 is a reply to message #447838] Thu, 18 March 2010 04:03 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What's in the log file?
Re: Data is not importing to table through SQL Loader when run through Forms [message #447869 is a reply to message #447847] Thu, 18 March 2010 05:03 Go to previous messageGo to next message
m.bhatkrishna@gmail.com
Messages: 6
Registered: September 2009
Junior Member
Hi,
Even its not generating log or .bad file when ran through forms however if i run through manually it gnerates properly withou problem..
Regards,
Krishna
Re: Data is not importing to table through SQL Loader when run through Forms [message #447892 is a reply to message #447869] Thu, 18 March 2010 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you verify whether TEST.BAT really has this name? If you wrote it using a certain text editor, perhaps it added its own ".TXT" extension (so the file's name is, actually, TEST.BAT.TXT)?
Re: Data is not importing to table through SQL Loader when run through Forms [message #447896 is a reply to message #447892] Thu, 18 March 2010 06:33 Go to previous messageGo to next message
m.bhatkrishna@gmail.com
Messages: 6
Registered: September 2009
Junior Member
Hi,
I am verified created .bat file is correct. there is no .txt attached to it. even i i click the .bat file , i loads properly.
Regards,
Krishna
Re: Data is not importing to table through SQL Loader when run through Forms [message #448751 is a reply to message #447896] Thu, 25 March 2010 01:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Does you answer mean that it is now working or that it is still not working?

David
Re: Data is not importing to table through SQL Loader when run through Forms [message #449436 is a reply to message #447838] Mon, 29 March 2010 09:22 Go to previous message
gregor
Messages: 86
Registered: March 2010
Location: Germany
Member
Hi m.bhatkrishna,

perhaps you should set ORACLE_HOME enviroment
to your Database-ORACLE-HOME in the test.bat-file.
Previous Topic: Calling URL from Forms with Locking the Form
Next Topic: record group query (merged by CM)
Goto Forum:
  


Current Time: Wed Sep 28 00:36:43 CDT 2016

Total time taken to generate the page: 0.12212 seconds