wrap_runnonq(“ [OLAP DML] “)
Public Sub wrap_runNonQ()
'Example of wrap_runNonQ and wrap_GetDML
Dim boo As Boolean
If Not oregistered Then: boo = regQ:
If Not o.connected Then
boo = o.connect
boo = o.connected Else
boo = True
End If
If boo = True Then
boo = o.wrap_runNonQ("shw tod") If boo = True Then
Debug.Print (o.wrap_getDML) 'You Could also use .mooGetDML here Else
Debug.Print o.getlastmooerr
End If
Else
Debug.Print "Unable to Connect"
Debug.Print o.getlastmooerr
End If
End Sub
A low level API that allows a client developer to execute Oracle OLAP DML statements directly within the Oracle OLAP environment. wrap_runNonQ does not request any output from the Oracle OLAP environment on execution.
Syntax
Example of an Excel VBA application using the wrap_runNonQ function:
Microsoft®, WINDOWS®, Microsoft Excel®, Microsoft Office® are registered trademarks of Microsoft Corporation.
ORACLE® is a registered trademark of ORACLE Corporation.
® SDMC Consulting Limited 2010
