469,609 Members | 1,657 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Problems with insert statement using SSL(Verisign)

mvr
Hi all

I are using IIS 5.0, Oracle 8.1.

I am having problem with the following Insert Statement when used on
Production Web server with SSL(https://...., Verisign).
This doesn't occur everytime. Our studies shows that it is occurring
approximately between1-2% of the total applications/Year(70-80K).
After adding some debugging, the insert statement, after failing, is giving
the following error:
Error NUmber: #-2147217833
Error Desc[Microsoft][ODBC driver for Oracle][Oracle]ORA-01401: inserted
value too large for column

Ironically, 75% of the time, when the users resubmit the page the record
will be inserted.

Insert into TABLE_NAME (APPLICANT_ID, ACAD_YR, SSN, FIRST_NAME, LAST_NAME,
MIDDLE_INITIAL, DATE_OF_BIRTH, STREET_ADDRESS, APARTMENT, CITY, STATE_CODE,
COUNTY_CODE, ZIP_CODE, EMAIL_ADDRESS, HOME_PHONE_NUMBER, OFF_PHONE_NUMBER,
FAX_PHONE_NUMBER, APPLICATION_RECD_DATE, MAIL_MEDIUM_IND, APP_TYPE_CODE,
GENDER_CODE, TITLE_FLAG, OWE_REPAY_FLAG)
Values (99057577,2005,'P00009775','TEST','BETA',Null,'02-FEB-1975','1940
BRENTWOOD',Null,'CITY','FL','37',12345,Null,Null,N ull,Null,'14-FEB-2005','S'
,'P','F','N','N')

I am thinking the problem is while the data is being transferred through
SSL(during the process of encryption and/or decryption it is inserting some
kind of junk characters?????)

While generating the sql I took every step to trim unwanted characters,
empty spaces but we are still getting the error.

Any suggestions will be really appreciated.

Thanks in advance
mvr

Jul 22 '05 #1
2 1680
http://www.aspfaq.com/etiquette.asp?id=5003

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"mvr" <v_*****@hotmail.com> wrote in message
news:uN****************@TK2MSFTNGP15.phx.gbl...
Hi all

I are using IIS 5.0, Oracle 8.1.

I am having problem with the following Insert Statement when used on
Production Web server with SSL(https://...., Verisign).
This doesn't occur everytime. Our studies shows that it is occurring
approximately between1-2% of the total applications/Year(70-80K).
After adding some debugging, the insert statement, after failing, is giving the following error:
Error NUmber: #-2147217833
Error Desc[Microsoft][ODBC driver for Oracle][Oracle]ORA-01401: inserted
value too large for column

Ironically, 75% of the time, when the users resubmit the page the record
will be inserted.

Insert into TABLE_NAME (APPLICANT_ID, ACAD_YR, SSN, FIRST_NAME, LAST_NAME,
MIDDLE_INITIAL, DATE_OF_BIRTH, STREET_ADDRESS, APARTMENT, CITY, STATE_CODE, COUNTY_CODE, ZIP_CODE, EMAIL_ADDRESS, HOME_PHONE_NUMBER, OFF_PHONE_NUMBER,
FAX_PHONE_NUMBER, APPLICATION_RECD_DATE, MAIL_MEDIUM_IND, APP_TYPE_CODE,
GENDER_CODE, TITLE_FLAG, OWE_REPAY_FLAG)
Values (99057577,2005,'P00009775','TEST','BETA',Null,'02-FEB-1975','1940
BRENTWOOD',Null,'CITY','FL','37',12345,Null,Null,N ull,Null,'14-FEB-2005','S' ,'P','F','N','N')

I am thinking the problem is while the data is being transferred through
SSL(during the process of encryption and/or decryption it is inserting some kind of junk characters?????)

While generating the sql I took every step to trim unwanted characters,
empty spaces but we are still getting the error.

Any suggestions will be really appreciated.

Thanks in advance
mvr

Jul 22 '05 #2
mvr
Hi all

After the suggest from on of the member(Thanks!!), I started writing SQL in
a text file.
The out come is:

One of my drop down box is having a default value as null but it displays
text as "SELECT NAME"
The code goes as follows
<select name = "selName">
<option value="" selected> SELECT NAME

My Request.Form("selName") is returning "SELECT NAME" instead of Null value.

This doesnot happen often, on resubmitting (the second submit) it retruns
Null.

Does any one ran into this situation.

Any suggestions and help will be really appreciated.

Thanks
Venkat
"mvr" <v_*****@hotmail.com> wrote in message
news:uN**************@TK2MSFTNGP15.phx.gbl...
Hi all

I are using IIS 5.0, Oracle 8.1.

I am having problem with the following Insert Statement when used on
Production Web server with SSL(https://...., Verisign).
This doesn't occur everytime. Our studies shows that it is occurring
approximately between1-2% of the total applications/Year(70-80K).
After adding some debugging, the insert statement, after failing, is giving the following error:
Error NUmber: #-2147217833
Error Desc[Microsoft][ODBC driver for Oracle][Oracle]ORA-01401: inserted
value too large for column

Ironically, 75% of the time, when the users resubmit the page the record
will be inserted.

Insert into TABLE_NAME (APPLICANT_ID, ACAD_YR, SSN, FIRST_NAME, LAST_NAME,
MIDDLE_INITIAL, DATE_OF_BIRTH, STREET_ADDRESS, APARTMENT, CITY, STATE_CODE, COUNTY_CODE, ZIP_CODE, EMAIL_ADDRESS, HOME_PHONE_NUMBER, OFF_PHONE_NUMBER,
FAX_PHONE_NUMBER, APPLICATION_RECD_DATE, MAIL_MEDIUM_IND, APP_TYPE_CODE,
GENDER_CODE, TITLE_FLAG, OWE_REPAY_FLAG)
Values (99057577,2005,'P00009775','TEST','BETA',Null,'02-FEB-1975','1940
BRENTWOOD',Null,'CITY','FL','37',12345,Null,Null,N ull,Null,'14-FEB-2005','S' ,'P','F','N','N')

I am thinking the problem is while the data is being transferred through
SSL(during the process of encryption and/or decryption it is inserting some kind of junk characters?????)

While generating the sql I took every step to trim unwanted characters,
empty spaces but we are still getting the error.

Any suggestions will be really appreciated.

Thanks in advance
mvr

Jul 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Adam Nims | last post: by
1 post views Thread by Ashutosh Bhalerao | last post: by
2 posts views Thread by Freddy | last post: by
reply views Thread by dinoo | last post: by
reply views Thread by SSLGuru | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.