Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

BUG: Package Call Fails if Parameters Are Not Present


View products that this article applies to.

This article was previously published under Q192778

↑ Back to the top


Symptoms

When you call an Oracle package.procedure that does not take any parameters the Microsoft Oracle ODBC driver returns the following error message:
SYNTAX ERROR OR ACCESS VIOLATION

↑ Back to the top


Resolution

To workaround this behavior, create a package.procedure that takes a parameter, but does nothing with the parameter.

↑ Back to the top


Status

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

↑ Back to the top


More information

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
				

↑ Back to the top


Keywords: KB192778, kbpending, kboracle, kbcode, kbbug

↑ Back to the top

Article Info
Article ID : 192778
Revision : 3
Created on : 10/15/2003
Published on : 10/15/2003
Exists online : False
Views : 300