Hi
Am trying to update VARVALUE field with more than 4000 Charecters which will be given in the text area of hrcex.html file.It is updating the data wchose length is less than 4000Charecters.Want to update data with more than 4000Charecters my table structure is like this and my code is like below.Pls make the necessary correction and send me at
[email protected]
Name Null? Type
----------------------------------------- -------- ---------------
SITEID VARCHAR2(20)
SITEDATE DATE
VARNAME VARCHAR2(100)
VARVALUE CLOB
hrcex.html
<html>
<head>
<title>Enter the SQL here</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
</head>
<body>
<form name="thisform" method="post" action="hrcu1.asp">
<div align="center"><center><p><big><strong>Enter the SQL to execute</strong></big></p>
</center></div><p><textarea name="sql" rows="3" cols="80"></textarea></p>
<div align="center"><center><p><input type="submit" name="submit" value="Submit"> <input
type="reset" name="reset" value="Reset"></p>
</center></div>
</form>
</body>
</html>
hrcu1.asp
<%
Dim OraSession
Dim OraDatabase
Dim Ora
Set OraSession = Nothing
Set OraDatabase = Nothing
Set Ora = Nothing
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set Ora = OraSession.DbOpenDatabase("ORA","LG/LG",cint(0))
VarValue = Replace(Request.Form("sql"),"'","''")
strSql = strSql & "update sitedata set VarValue ="
strSql = strSql & " ' " & VarValue & " ' where siteid='FVS' and VarName='txtLink' "
Response.write( "Going to fire the following SQL<br>" & strSql )
Ora.ExecuteSQL strSql
Response.write( "SQL execute success")
%>
Thanks Sagarika
[email protected]
ASP UPDATE CLOB
