PRB: "Unclosed Quote" Error when Calling Oracle Stored Procedure

 Last reviewed: December 11, 1997
Article ID: Q175090
The information in this article applies to:
  • Microsoft Visual InterDev, version 1.0

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/support/vinterdev/


Keywords          : kberrmsg
Technology        : kbInetDev
Version           : WINDOWS:1.0
Platform          : WINDOWS
Issue type        : kbprb

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.