Steps to Reproduce Behavior
In SQL*PLUS run the following Oracle PL/SQL code:
create or replace package pack1 is
procedure proc1;
end pack1;
/
create or replace package body pack1 is
procedure proc1 is
begin
insert into department values (50,'RESEARCH', 124);
end proc1;
end pack1;
/
To reproduce the error use the following Visual Basic code in a push button
Click event. Make sure that the Visual Basic project has the Microsoft
ActiveX Data Objects Library selected in the REFERENCES
Private Sub Command2_Click()
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Dim m_session As ADODB.Connection
Set m_session = New ADODB.Connection
m_session.CursorLocation = adUseClient
' Replace "***" with your own Oracle DSN
m_session.Open "DSN=***", "demo", "demo"
Set cmd = New ADODB.Command
cmd.ActiveConnection = m_session
cmd.CommandText = "pack1.proc1"
cmd.CommandType = adCmdStoredProc
cmd.Execute
End Sub