OraFAQ Forum: Forms » About SQL Loader in Form

Home » Developer & Programmer » Forms » About SQL Loader in Form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About SQL Loader in Form [message #312066]

Mon, 07 April 2008 21:56

ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh

Member

Dear Sir;
currently im using SQLLoader in Dev6i and Database oracle 8.1.7;
it is working as well in DELL PC;But in HP Pc it is Not working i.e Data is Not loaded in HP PC.

Pls Give Solution What is the Problem,....

-----------------My Code-----------------------
DECLARE
DAT_FILE varchar2(200) := GET_FILE_NAME( directory_name => 'D:\DATA',
file_filter => 'DATA (*.TXT)|*.TXT|',
dialog_type => open_file, select_file => TRUE);
BEGIN
if DAT_FILE is not null then
HOST('SQLLDR oral/myorcl CONTROL=D:\DATA\DATA.CTL DATA='||DAT_FILE);
end if;
END;

Report message to a moderator

Re: About SQL Loader in Form [message #312138 is a reply to message #312066]

Tue, 08 April 2008 01:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Any error (both in a form or SQL*Loader session)? How does the log file look like? Oh, you don't have one specified in the command line! Include it and try again - such as

SQLLDR oral/myorcl CONTROL=d:\data\data.ctl LOG=data.log

Report message to a moderator

Previous Topic:	How to create dynamic ddl -create table using pl/sql
Next Topic:	Need Time stamp value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 10:23:28 CDT 2024