Oracle Provider –> SQL*Plus script error

Asked By 30 points N/A Posted on -

Hello TechyV buddies!

I am having some problem using Oracle and ASP.NET. I was using PHP Codeigniter before but now due to the demand I have shifted using Oracle and ASP.NET. on the process of installing the scripts for ODP for visual studio, an error occurred.

"object reference not set to an instance of an object"

Accessing my database from the model and controllers via entity framework is not a problem. My problem is, I want to recreate a table that is required for the membership API, but it wants me to do it manually. Is there any way that I can recreate without doing it manually? Can anyone help me with this? Any help will be highly appreciated. Thank you!

Answered By 0 points N/A #147254

Oracle Provider –> SQL*Plus script error


Hello Elias,

The error that you are getting is most probably a .net code error, and it is most likely  caused by a failed database call. A procedure that needs to return a value is called, but due to that issue it will not be able to return value, instead it will bring a null value.

This could be resulting because .net is losing connection to Oracle. That could be because .Net is not able to maintain session information where there could be a connection string that has been encrypted. To resolve that error therefore, you will need to go to the cookies use them instead of relying on the .Net session.

Hope this helps.




Login/Register to Answer

Related Questions