Skip to content

Instantly share code, notes, and snippets.

@cx20
Created June 10, 2012 14:27
Show Gist options
  • Save cx20/2905910 to your computer and use it in GitHub Desktop.
Save cx20/2905910 to your computer and use it in GitHub Desktop.
Hello, oo4o World! (VBScript + oo4o + Oracle)
Option Explicit
Call Main()
Sub Main()
Dim ses
Dim db
Dim rs
Set ses = CreateObject("OracleInProcServer.XOraSession")
Set db = ses.OpenDatabase( "", "scott/tiger", 0 )
Set rs = db.CreateDynaset( "SELECT 'Hello, oo4o World!' AS Message FROM DUAL", 4)
While NOT rs.EOF
WScript.Echo rs(0).Name
WScript.Echo "------------------"
WScript.Echo rs(0).Value
rs.MoveNext
Wend
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment