| SQL LOADER at oracle form [message #156685] |
Fri, 27 January 2006 00:59  |
voralux
Messages: 72
Registered: January 2006
|
Member |
|
|
I would like to insert data ~ 5000 record, to Table & If I use Function: Insert INTO TABLE (Field1,...) values (Field1,...)
~ 30 minutes
so I would like use function SQL Loader at Oracle Form, But I don't know statement.
|
|
|
|
| Re: SQL LOADER at oracle form [message #156712 is a reply to message #156685] |
Fri, 27 January 2006 04:42  |
vban2000
Messages: 207
Registered: March 2005
|
Senior Member |
|
|
Hi voralux
Search for Hosts command on the Form Builder.
Remeber the following must in one line!
hosts ('sqlldr control=sql_fn.ctl userid=username/password@connection_string');
FYI, you might want to search the GET_APPLICATION_PROPERTY function and look up on the following parameters:
(1) PASSWORD
(2) USERNAME
(3) CONNECT_STRING
Rregrards
AnDy
|
|
|
|
| Re: SQL LOADER at oracle form [message #156935 is a reply to message #156712] |
Mon, 30 January 2006 03:30 |
voralux
Messages: 72
Registered: January 2006
|
Member |
|
|
I create & cannot success
PROCEDURE TEST IS
cmd varchar2(2000);
BEGIN
cmd := ('sqlldr control=$PO_TOP/bin/trequpload.ctl userid=username/password@test');
host(cmd);
END;
Please recommend,
|
|
|
|
| Re: SQL LOADER at oracle form [message #156941 is a reply to message #156685] |
Mon, 30 January 2006 04:16 |
vban2000
Messages: 207
Registered: March 2005
|
Senior Member |
|
|
Hi voralux
Perhaps you can have look at your log file and spot the reason why it is not loaded.
and if you run the sqlldr command (sqlldr control=$PO_TOP/bin/trequpload.ctl userid=username/password@test) from the O/S, does it load?
Regards
AnDy
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
