| sqlplus returning output values [message #257526] |
Wed, 08 August 2007 10:00  |
raj_23
Messages: 7
Registered: July 2007
|
Junior Member |
|
|
Set loShell = wscript.CreateObject("WScript.Shell")
'Start populate the tables.
lcsCommand = "sqlplus " & gmJobInfo("FaUserId") & "/" & gmJobInfo("ActualPassword") _
& "@" & gmJobInfo("Datasource") & " @""" & lstrConfigDir & "Runstep1.ini"" " _
& gmJobInfo("IsScheduled")
WshShell.Run lcsCommand, 10, True
Above is an example.. I am running sqlplus from VBScript Shell..
Is there any way you can receive an output variable from the SQLPLUS to a VBScript variable...
(maybe stored proc o/p variable ?)
|
|
|
|
|
|
| Re: sqlplus returning output values [message #257796 is a reply to message #257534] |
Thu, 09 August 2007 03:22  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Surely there is some way of integrating SQL with VB other than calling SQL*Plus. OCI or ODBC?
Calling an OS script is low-tech and prone to failure. It's just bad I.T.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
