2 Replies Latest reply: Oct 14, 2013 4:36 PM by 94783fd9-a20d-4971-88ad-48c4b003fc3a RSS

    Issue while selecting XMLType column in Oracle 10G

    94783fd9-a20d-4971-88ad-48c4b003fc3a

      HI All.

           We are trying to get some value from XML Type column and it works fine with Oracle 11g, we are trying the same with Oracle 10g but it fails with below  stack Trace . looking at the stack Trace we feel it is the issue with ODP.net ,

       

      we have below oracle Versions installed in our Server .

      Oracle Data Access Components    ---  10.2.0.2.21

      Oracle Database 10g Release 2 Patch Set 3  --- 10.2.0.4.0

       

      Kindly let us know if it is specific to any ODP.net issue, or anyone has some sought of work around to resolve this issue .

       

       

      -----------Stack Trace --------------------------------------------------------

      Message: Exception has been thrown by the target of an invocation.

       

      StackTrace:    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

         at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

         at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

         at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

         at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)

         at System.Web.Services.Protocols.WebServiceHandler.Invoke()

         at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

         at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)

         at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)

         at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

         at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

         at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)

         at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

         at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

         at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)

         at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

       

       

      InnerException: System.AccessViolationException

       

      Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

       

      StackTrace:    at Oracle.DataAccess.Types.OpsXmlStream.GetValueBuffer(IntPtr opsConCtx, IntPtr opsErrCtx, IntPtr opsXmlTypeCtx, IntPtr& opsXmlStreamValueBuffer, Int32& numCharsInBuffer)

         at Oracle.DataAccess.Client.OracleDataReader.GetString(Int32 i)

         at Oracle.DataAccess.Client.OracleDataReader.GetValue(Int32 i)

         at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()

         at ProVation.DataAccess.CProvDatabase.GetScalar(SQLText& sql, Object& returnval, String& user)

         at ProVation.DataAccess.CProvDatabase.GetScalar(SQLText& sql, String& returnval, String defaultvalue, String& user)

         at ProVation.BusinessRules.ConfigsBR.GetDocumentXML(String specialty, Boolean isProvationXML, Boolean isEdit)

         at ProVation.BusinessRules.ConfigsBR.GetTreeXML(String terminal, String site, String speciality, DataSet& ds, DataSet& dsXML)

         at WKOSAWS.GetTreeXML(String terminal, String key, String strSpeciality, String strSite, DataSet& dsSpeciality) in c:\inetpub\wwwroot\WKOSAWS\App_Code\WKOSAWS.cs:line 207

       

       

      Thanks in Advance

      Suren