Fault Exception Handling in WCF

While throwing exception from my WCF service . iam getting the following error message

FaultException `1 was un handled by user code

 

System.ServiceModel.FaultException`1 was unhandled by user code

  Message="Oracle.DataAccess.Client.OracleException ORA-20003: EmpNo (Exxxx) Dosent Exists Or Dont have sufficent previlage\nORA-06512: at \"PKG\", line 38\nORA-06512: at \"PKG\", line 39\nORA-06512: at line 1    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)\r\n   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)\r\n   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)\r\n   at Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\r\n   at SQLManager.Oracle.DataAccess.ExecuteDataSet(ExecuteDataSetParameterMessage parameter) ..........

 
i have enclosed the code below

private void ProcessException(string message, Exception innerException)
{
SqlManagerException ex = new SqlManagerException(message, innerException);
 
            
 
if (Messages != null)
{
  for (int i = 0; i < messages.Count; i++)
  {
       ex.InfoMessages.Add(messages[i]);
     }
  }
  SqlManagerExceptionMessage exm = new SqlManagerExceptionMessage(ex);
 
  faultReason = new FaultReasonText(exm.Message.InnerException.ToString());
 
  exm.Message = ex;
  throw new FaultException<SqlManagerExceptionMessage>(new SqlManagerExceptionMessage(exm.Message), faultReason.Text);
 
}
And the SqlManagerExceptionMessage .cs is 
 
using System.ServiceModel;
using System.Runtime.Serialization;
 
namespace SQLManager
{
 
    [DataContractAttribute]
    public class SqlManagerExceptionMessage
    {
        [DataMember]
        private SqlManagerException report;
 
 
        public SqlManagerExceptionMessage(SqlManagerException message)
        {
            this.report = message;
        }
 
        [DataMemberAttribute]
        public SqlManagerException Message
        {
           get { return this.report; }
            set { this.report = value; }
        }
        
 
        //public SqlManagerException Exception
        //{
        //    get { return exception; }
        //    set { exception = value; }
        //}
    }
}
 
 
SqlManagerException .cs is 
 
 [Serializable()]
	public class SqlManagerException : ApplicationException,ISerializable
	{
        private SqlManagerInfoMessageList messages;
 
        public SqlManagerException() : base() { }
 
        public SqlManagerException(string message) : base(message) { }
 
        public SqlManagerException(string message,
            Exception innerException)
            : base(message, innerException) { }
                      
        public SqlManagerException(SerializationInfo info, StreamingContext context) : base(info, context) 
        {             
            messages = (SqlManagerInfoMessageList)info.GetValue("messages", typeof(SqlManagerInfoMessageList));            
        }
 
 
        public override void GetObjectData(SerializationInfo info, StreamingContext context)
        {
            info.AddValue("messages", messages, typeof(SqlManagerInfoMessageList));
            base.GetObjectData(info, context);
        }
		
        /// <summary>A collection of information messages retrieved from connection.</summary>
        public SqlManagerInfoMessageList InfoMessages
        {
            get
            {
                if (messages == null)
                {
                    messages = new SqlManagerInfoMessageList();
                }
			    
                return messages;
            }
 
            set
            {
                messages = value;
            }
        }
        
		
    }
}

Select allOpen in new window