Home » Developer & Programmer » Forms » About SQL Loader in Form
icon9.gif  About SQL Loader in Form [message #312066] Mon, 07 April 2008 21:56 Go to next message
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;
Re: About SQL Loader in Form [message #312138 is a reply to message #312066] Tue, 08 April 2008 01:30 Go to previous message
Littlefoot
Messages: 20900
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
Previous Topic: How to create dynamic ddl -create table using pl/sql
Next Topic: Need Time stamp value
Goto Forum:
  


Current Time: Wed Dec 07 14:43:13 CST 2016

Total time taken to generate the page: 0.09763 seconds