Oracle Provider –> SQL*Plus script error

Asked By elias cooper 30 points N/A Posted on - 08/16/2012

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!

• Status: Open
• Question Views: 831
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Carl Jack 10 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.

Regards,

Carl

 

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/29/2012
• Question Category: MS SQL Server