troubleshooting Question

ORA-01036 error because of comment and text contained within comment.

Avatar of ciphersol
ciphersol asked on
Oracle Database.NET Programming
4 Comments1 Solution769 ViewsLast Modified:
I am using the "Oracle.DataAccess" class library with VB.NET.  The code executes SQL statements that apply updates to a database.   I have found an unusual issue where I receive the error "ORA-01036: illegal variable name/number" when executing the following statement:

CREATE OR REPLACE PROCEDURE TEST_PROC IS
BEGIN
NULL;
/** COMMENT: */
END TEST_PROC;

The error can be eliminated by modifying the comment from "/**" to "/*" so that the statement looks like the following:

CREATE OR REPLACE PROCEDURE TEST_PROC IS
BEGIN
NULL;
/* COMMENT: */
END TEST_PROC;

The command runs perfectly fine in SQL*Plus but not using the "Oracle.DataAccess" class (ExecuteNonQuery command).  Modifying the statement is not an option.

Any ideas on how to correct this problem?

Oracle Database Version:  Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Oracle.DataAccess Version: 9.2.0.700   and  10.2.0.100
ASKER CERTIFIED SOLUTION
Devinder Singh Virdi
Lead Oracle DBA Team

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros