Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- From: "Patrick.O.Ige" <patrickige@xxxxxxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 09:43:09 +1100
Is this how you use stored proc when using ORACLE "cmBS.CommandText =
"OracleInstance.GETBLANKETSTATUS.procListBlanketStatus";
"?
And are you sure your connection string is ok.
"petro" <petro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:10986F0B-E9C5-44E3-9722-C806E24F219B@xxxxxxxxxxxxxxxx
> Hello all,
> My asp.net web application works on my machine but I get the following
error
> on our test web server, There is only one oracle home on the test server.
> Does anyone know how to resolve this error?
>
> Oracle error occurred, but error message could not be retrieved from
Oracle.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
about
> the error and where it originated in the code.
>
> Exception Details: System.Data.OleDb.OleDbException: Oracle error
occurred,
> but error message could not be retrieved from Oracle.
>
> Source Error:
>
>
> Line 220: cmBS.CommandType = CommandType.StoredProcedure;
> Line 221: cmBS.CommandText =
> "OracleInstance.GETBLANKETSTATUS.procListBlanketStatus";
> Line 222:
> Line 223: OleDbDataAdapter daBS = new OleDbDataAdapter();
> Line 224: daBS.SelectCommand = cmBS;
>
>
> Source File: c:\inetpub\wwwroot\Myfile\myaspxpage.aspx.cs Line: 222
>
> Stack Trace:
>
>
> [OleDbException (0x80004005): Oracle error occurred, but error message
could
> not be retrieved from Oracle.]
> System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
> System.Data.OleDb.OleDbConnection.InitializeProvider() +57
> System.Data.OleDb.OleDbConnection.Open() +203
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior) +304
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecor
d,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> behavior) +77
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36
> WebReportMenu.BlanketContract.getData() in
> c:\inetpub\wwwroot\webreportmenu\blanketcontract.aspx.cs:222
> WebReportMenu.BlanketContract.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\webreportmenu\blanketcontract.aspx.cs:102
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750
>
>
>
>
> --------------------------------------------------------------------------
------
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET
> Version:1.1.4322.2032
>
>
.
- Follow-Ups:
- Prev by Date: Re: Share VB code across multiple pages?
- Next by Date: What materials ?
- Previous by thread: detect https
- Next by thread: Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- Index(es):
Relevant Pages
|
