| Oracle Objects for OLE (OO4O) [message #101361] |
Thu, 26 August 2004 23:49  |
Halvard Gjøystdal
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
I have a package with name: H_SCHEDULER.STOPP_SCHEDULER.
I run this in SQL in this way:
execute H_SCHEDULER.STOPP_SCHEDULER
And that works OK.
I have now created a Visual Basic 6.0 program with following line:
Dim OraSession As Object 'Declare variables as OLE Objects
Dim OraDatabase As Object
Dim OraDynaset As Object
Set OraSession =CreateObject ("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("EUROPA", "xxxxx/yyyyy", 0&)
csql = "EXECUTE H_SCHEDULER.STOPP_SCHEDULER"
r = OraDatabase.dbExecuteSQL(csql)
But when i try to run the program i get an error:
Run-time error '440'
Sql execution error, ora-00900: invalid SQL statement
So my questions is: What is wrong with my VB code......
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
