Strange Problem. Unable to run stored procedure:

6 Jul 2006 2:29 PM

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.

6 Jul 2006 3:36 PM

Paul Clement

On 6 Jul 2006 07:29:54 -0700, "MPutt" <mark.p***@gmail.com> wrote:

¤ 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)

6 Jul 2006 4:45 PM

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

Paul Clement wrote:
Show quote

> On 6 Jul 2006 07:29:54 -0700, "MPutt" <mark.p***@gmail.com> wrote:
>
> ¤ 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)