Anyone seen this before.

[MPutt]

I apologize if I am posting this to the wrong area, but I am stuck.
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 .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?
I have posted to an Oracle group as well. I hope someone has some
ideas.


THanks.
Mark.

 

[Norman Yuan]

Where di dyou get this error? How do you handle error in the Windows
Service? Does the Windows Service stop due to the error.

It is very difficult to say what is wrong, but I'd first look into the user
account that is used to run the Windows Service. Does the account have
permission to run the SP on the database? Or you can run the Windows Service
under an user account that you know for sure is allowed to execute the said
SP on the database, to see what happens.