Microsoft KB Archive/175090: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 12: | Line 12: | ||
<div id="TitleRow"> | <div id="TitleRow"> | ||
= <span id="KB175090"></span>PRB: | = <span id="KB175090"></span>PRB: "Unclosed Quote" Error when Calling Oracle Stored Procedure = | ||
Line 51: | Line 51: | ||
[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote before the character string ' '.<br /> | [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quote before the character string ' '.<br /> | ||
<br /> | <br /> | ||
<asp file name and line number> | |||
</div> | </div> | ||
Line 79: | Line 79: | ||
# Open the Data Command Control. | # Open the Data Command Control. | ||
# Manually enter your stored procedure name (for example, | # Manually enter your stored procedure name (for example, "my_stored_proc") in the Command Text property box. | ||
# Close the control and preview the page. | # Close the control and preview the page. | ||
# It works. If you open the control again and close it, it still works. | # It works. If you open the control again and close it, it still works. | ||
Line 103: | Line 103: | ||
# Insert a Data Command Control. | # Insert a Data Command Control. | ||
# Choose the data connection created in step 2 above from the Data Connection drop-down list box. | # Choose the data connection created in step 2 above from the Data Connection drop-down list box. | ||
# Choose | # Choose "Stored Procedure" from the "Command Type" drop-down list box. | ||
# Choose one of the stored procedures available to your database from the Command Text drop-down list box. | # Choose one of the stored procedures available to your database from the Command Text drop-down list box. | ||
# Save and preview the ASP file. | # Save and preview the ASP file. |
Latest revision as of 11:07, 21 July 2020
Article ID: 175090
Article Last Modified on 5/2/2006
APPLIES TO
- Microsoft Visual InterDev 1.0 Standard Edition
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:
CAUSE
The conditions that cause this error are as follows:
- Making a call to an Oracle stored procedure.
- Using the Data Command Control to insert the ActiveX Data Objects (ADO) code that accesses the stored procedure.
- Editing and closing the Data Command Control at least once after initially inserting the control.
- 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
- Open the Data Command Control.
- Manually enter your stored procedure name (for example, "my_stored_proc") in the Command Text property box.
- Close the control and preview the page.
- 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
- Open or create a Visual InterDev project.
- Add a data connection to an Oracle database.
- Add a new ASP page to the project.
- Insert a Data Command Control.
- Choose the data connection created in step 2 above from the Data Connection drop-down list box.
- Choose "Stored Procedure" from the "Command Type" drop-down list box.
- Choose one of the stored procedures available to your database from the Command Text drop-down list box.
- 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:
Keywords: kberrmsg kboracle kbide kbprb KB175090