|
| .net oracleclient truncate data |
 |
Mon, 17 Mar 2008 05:58:13 +000 |
BACKGROUND:
I need to retrieve survey wise data from oracle grouped by mobile number that
returns me the count of SMS by mobile no aganist a survey.
I write an C#.net exe which collect those data per day. Here i use
OracleClient.
MY CODE SAMPLE LOOKS LIKE:
objConn = new OracleConnection(sOracleConn);
sSql = "SELECT MobileNo,CAST(TRIM(Survay_ID)AS CHAR(50)) Survay_Id,Count(*)
AS Counter FROM(SELECT DISTINCT MobileNo,UPPER(TRIM(Survay_ID))
Survay_ID,Survay_Text FROM tbl_Survay WHERE FLAG=1 AND UPPER(TRIM(Survay_ID))
IN(" + sSurveyIDS + ") AND TRUNC(Insert_Date)='" + strDate +
"') tbl GROUP BY MobileNo,Survay_ID";
objConn.Open();
objCmd = new OracleCommand(sSql, objConn);
da = new OracleDataAdapter(objCmd);
Surveydt = new DataTable();
da.Fill(Surveydt);
objConn.Close();
// WRITE EACH DATAROW IN A LOG FILE
AFTER READING THE DATA I WILL MATCH MOBILE NO WITH A SQL SERVER DATABASE &
UPDATE SQL SERVER DATA ACCORDING TO THE MOBILENO.
MY PROBLEM IS SOMETIMES I MISSED THE DATA. WHEN I CHECKED MY LOG FILE THEN I
FOUND THAT IN Surveydt(look @ code sample) DATATABLE I FOUND MOBILE NO LIKE(LOOK
SPACES AFTER 17194):
Mobile No 17194 not updated for survey=198
WHEN I CHECKED THE ORACLE I WILL GET MOBILE NO=1719478182
IN LOGFILE THE CHARACTERS REPLACED BY SPACE.
IF I MANUALLY RUN I DIDN'T GET THIS PROBLEM BUT WHEN I AM GOING TO PRODUCTION
EACH DAY I RECEIVED 2 TO 3 SUCH TYPE OF TRUNCATED MOBILE NO.
ANY HELP?
|
| Post Reply
|
|
|
|
|
|
|
|
|
|