I have an ASP.NET application which works fine in the development environment and it does not work in testing environment.
I am calling a procedure in oracle 8i which is part of the package and the call works just fine in development (which has Oracel 9i) but in testing the call fails with an error which is already killing me.
In Toad i can trace the incomming request from development but i do not even see trace log of any request from testing server.I mean could it be possible that only for this procedure the request is not even hitting the backend and for several others it is just fine and excutes without any problem.
Following is the error and i have checked the procedure which works absolutely fine in Oracle.
ORA-06550: line 1, column 32: PLS-00103: Encountered the symbol ">" when expecting one of the following: from
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.OracleClient.OracleException: ORA-06550: line 1, column 32: PLS-00103: Encountered the symbol ">" when expecting one of the following: from
Stack Trace:
[OracleException: ORA-06550: line 1, column 32:
PLS-00103: Encountered the symbol ">" when expecting one of the following:
from
]
- Code: Select all
System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) +170
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals) +1917
System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, ArrayList& refCursorParameterOrdinals) +28
System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) +271
System.Data.OracleClient.OracleCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
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 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
parkingLib.COracle.RunQuery() in c:\parking\aidatalib\coracle.cs:111
parkingDATALib.COracle.RunQuery(String sStoredProcedure, Object[] paramArr) in c:\parking\aidatalib\coracle.cs:173
parkingLib.Load.CancelPermitsByYear(String year) in c:\parking\acm_rdilib\load.cs:166
parkingWeb.ImportExport.CancelPermits.imgButtonCancelPermit_Click(Object sender, ImageClickEventArgs e) in c:\rdi_24oct2005\parkingweb\importexport\cancelpermits.aspx.cs:85
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +109
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
Any help would be appreciated.
Thanks
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
