Home » RDBMS Server » Server Utilities » SQL Loader and VB
SQL Loader and VB [message #368019] Fri, 08 October 1999 16:08 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Default storage parameter
Next Topic: SQL Loader and Binary Data Files
Goto Forum:
  


Current Time: Fri Mar 29 05:16:25 CDT 2024