PRB: "Unclosed Quote" Error when Calling Oracle Stored Procedure (175090)


The information in this article applies to:

  • Microsoft Visual InterDev 1.0
This article was previously published under Q175090

SYMPTOMS

The following error occurs when previewing an Active Server Pages (ASP) page that calls an Oracle stored procedure:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote before the character string ' '.

<asp file name and line number>

CAUSE

The conditions that cause this error are as follows:
  1. Making a call to an Oracle stored procedure.
  2. Using the Data Command Control to insert the ActiveX Data Objects (ADO) code that accesses the stored procedure.
  3. Editing and closing the Data Command Control at least once after initially inserting the control.
  4. Choosing the stored procedure name from the Command Text drop-down list box in the Data Command's property sheet.
The Data Command Control incorrectly parses the Command Text being assigned to the cmdText object. The second time the DataCommand Control is opened it parses the sting as follows: 
   cmdTemp.CommandText = 'dbo.''my_stored_proc'''
Which should be the following: 
   cmdTemp.CommandText = 'dbo.my_stored_proc'

RESOLUTION

  1. Open the Data Command Control.
  2. Manually enter your stored procedure name (for example, "my_stored_proc") in the Command Text property box.
  3. Close the control and preview the page.
  4. It works. If you open the control again and close it, it still works.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open or create a Visual InterDev project.
  2. Add a data connection to an Oracle database.
  3. Add a new ASP page to the project.
  4. Insert a Data Command Control.
  5. Choose the data connection created in step 2 above from the Data Connection drop-down list box.
  6. Choose "Stored Procedure" from the "Command Type" drop-down list box.
  7. Choose one of the stored procedures available to your database from the Command Text drop-down list box.
  8. Save and preview the ASP file.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/search/default.aspx?qu=vinterdev

Modification Type:MajorLast Reviewed:5/2/2006
Keywords:kberrmsg kbide kbOracle kbprb KB175090
©2004 Microsoft Corporation. All rights reserved.