SQL Loader and VB [message #368019] |
Fri, 08 October 1999 16:08 |
Meghan O'Sullivan
Messages: 2 Registered: October 1999
|
Junior Member |
|
|
Does anyone know if it is possible to call sqlldr from Visual Basic - somehow invoke svrmgrl or something? We are trying to automate some dataload and really need suggestions. Thanks!
Meghan
|
|
|
Re: SQL Loader and VB [message #368021 is a reply to message #368019] |
Fri, 08 October 1999 16:35 |
Thomas
Messages: 67 Registered: September 1999
|
Member |
|
|
Hi !
Do you work on NT ? You can use the "at" command for stuff like that. Or use the Enterprise Manager
on all Platforms ! This works fine !
On UNIX itīs also no problem to use cron or at using commands like "
su - oracle -c /opt/oracle.../scriptname"
and the scriptname includes text like:
svrmgrl <<EOF
connect system/manager
select * from v$database;
exit
eof
Thomas
|
|
|
Re: SQL Loader and VB [message #368030 is a reply to message #368021] |
Wed, 13 October 1999 16:02 |
Meghan O'Sullivan
Messages: 2 Registered: October 1999
|
Junior Member |
|
|
We work in NT but the server is solaris. the challenge is invoking sqlldr on the Sun but through VB. The files exist on the solaris box but now how do I get them to load without telneting over? I want VB to control the whole process.
|
|
|