Strange Problem. Unable to run stored procedure:

[MPutt]

I apologize if I am posting this to the wrong area.
Here is my problem.

I am running a .NET 2003 Windows service against Oracle 9i. This
service is attempting to run a stored proc that inserts data into the
DB. When it calls the proc it gets the following error.


"Unable to run stored procedure: "


It doesn't return the name of the procedure or an error number or
anything useful. I know what proc it is calling but I have no idea
what error it is actualy getting. I have tracked this all the way down

into the ADO .NET oracle provider and I still see no error number.


I have run this exact code against another instance of the database and

I DO NOT get the error. So, one DB throws the error and one does not.


Has anyone see this before?


THanks.
Mark.

 

[Paul Clement]

¤ I apologize if I am posting this to the wrong area.
¤ Here is my problem.
¤
¤ I am running a .NET 2003 Windows service against Oracle 9i. This
¤ service is attempting to run a stored proc that inserts data into the
¤ DB. When it calls the proc it gets the following error.
¤
¤
¤ "Unable to run stored procedure: "
¤
¤
¤ It doesn't return the name of the procedure or an error number or
¤ anything useful. I know what proc it is calling but I have no idea
¤ what error it is actualy getting. I have tracked this all the way down
¤
¤ into the ADO .NET oracle provider and I still see no error number.
¤
¤
¤ I have run this exact code against another instance of the database and
¤
¤ I DO NOT get the error. So, one DB throws the error and one does not.
¤
¤
¤ Has anyone see this before?

That's all you get? If it's an Oracle error there should an ORA error number that precedes the rest
of the message text.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[MPutt]

I know it's very odd and frustrating, but there is no Oracle error.
There is hardly any useful info at all.

I get this on an inner exeption
hresult -2146233087

and this is a COM+ error
-532459699