Hello
We work with Map 5, an ORACLE - DB and the CAO- Object [creating in LISP :
(setq *dbConnect* (vlax-get-or-create-object "CAO.DbConnect")) ]
using LinkTemplates, Links and so on.
Now we want to use ORACLE - PL/SQL- procedures stored in packages.
At the moment we start procedures (proc-name is "SelectGeoObjectsProject"
in a pl/sql - package "acadtest") using ADO-object (in VBA), like :
Dim Oracon As ADODB.Connection
Dim Recset As New ADODB.Recordset
Dim cmd As New ADODB.Command
cmd.CommandType = adCmdText
Set param1 = cmd.CreateParameter("param1", adNumeric, adParamInput, , InputValue)
cmd.Parameters.Append param1
Set param2 = cmd.CreateParameter("param2", adNumeric, adParamOutput)
cmd.Parameters.Append param2
cmd.CommandText = "{CALL acadtest.SelectGeoObjectsProject(?,?)}"
Is it possible to start ORACLE - PL/SQL- procedures
(but also SQL-statements like "insert into dummy where ...." via CAO - object,
so we have not to establish two DB-connections?
Another way could be Object ARX.
How can I start ORACLE - procedures in Object ARX?
Cheers, Steffen / IDP (idp.de)
