By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,569 Members | 1,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,569 IT Pros & Developers. It's quick & easy.

URGENT - VB.Net and Oracle Client, 'random' error

P: n/a
Hi, it would be fantastic if anyone could suggest a solution to this
problem.

I've written an ASP.Net (VB) application which uses stored procedures
in Oracle. All seems fine, except occasionally I get the error below:

[NullReferenceException: Object reference not set to an instance of an
object.]
System.Data.OracleClient.OciHandle.op_Implicit(Oci Handle x) +23
System.Data.OracleClient.TracedNativeMethods.OCIAt trGet(OciHandle
trgthndlp, Int32& attributep, Int32& sizep, ATTR attrtype, OciHandle
errhp) +59
System.Data.OracleClient.OciHandle.GetAttribute(AT TR attribute,
Int32& value, OciHandle errorHandle) +37
System.Data.OracleClient.OracleCommand.ExecuteNonQ ueryInternal(Boolean
needRowid, OciHandle& rowidDescriptor) +171
System.Data.OracleClient.OracleCommand.ExecuteNonQ uery() +57
SAMI.cls_User.Load() in
C:\Inetpub\wwwroot\SAMI\Classes\cls_User.vb:123
SAMI.LoginControl.Page_Load(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\SAMI\default.aspx.vb:43
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +725

This error seems to ocur inside the OracleClient DLL. The database is
9i.

I haven't posted and code because all the code works 99% of the time.
Also the error doesn't occur on one particular procedure call - it can
occur on any one of them...it all seems a bit arbitary.

This is live, and embarrassing.

Any ideas??

Rich.
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Can you check the number of connections that Oracle is using? Does it happen
when there are a large number of users?

We found that Oracle was running out of connections at times. I think you
need to be careful to pool or reuse connections. I can't help much more than
that because I wasn't the DBA at that place, just the Web developer.

"Freebeerboy" <ri***********@gmail.com> wrote in message
news:8e*************************@posting.google.co m...
Hi, it would be fantastic if anyone could suggest a solution to this
problem.

I've written an ASP.Net (VB) application which uses stored procedures
in Oracle. All seems fine, except occasionally I get the error below:

[NullReferenceException: Object reference not set to an instance of an
object.]
System.Data.OracleClient.OciHandle.op_Implicit(Oci Handle x) +23
System.Data.OracleClient.TracedNativeMethods.OCIAt trGet(OciHandle
trgthndlp, Int32& attributep, Int32& sizep, ATTR attrtype, OciHandle
errhp) +59
System.Data.OracleClient.OciHandle.GetAttribute(AT TR attribute,
Int32& value, OciHandle errorHandle) +37
System.Data.OracleClient.OracleCommand.ExecuteNonQ ueryInternal(Boolean
needRowid, OciHandle& rowidDescriptor) +171
System.Data.OracleClient.OracleCommand.ExecuteNonQ uery() +57
SAMI.cls_User.Load() in
C:\Inetpub\wwwroot\SAMI\Classes\cls_User.vb:123
SAMI.LoginControl.Page_Load(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\SAMI\default.aspx.vb:43
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +725

This error seems to ocur inside the OracleClient DLL. The database is
9i.

I haven't posted and code because all the code works 99% of the time.
Also the error doesn't occur on one particular procedure call - it can
occur on any one of them...it all seems a bit arbitary.

This is live, and embarrassing.

Any ideas??

Rich.


Nov 18 '05 #2

P: n/a
Thanks for the suggestion. I would probably expect a 'proper' Oracle
error in that situation, but I'll look into it anyway to be sure.

Cheers
Rich.
Nov 18 '05 #3

P: n/a

Hi,

Our system has gone live since last 15 days and we are facing this
problem left right and center. Did anyone got the solution for this
problem. Pl. let me know.

Thank you in advance,

Snehal
--
srana
------------------------------------------------------------------------
srana's Profile: http://www.highdots.com/forums/m1148
View this thread: http://www.highdots.com/forums/t665094

Nov 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.