Hi
when am entering charecters<4000 then there is no error when it is exceeding this following error is coming
Error Type:
Oracle Automation (0x800A01B8)
SQL execution error, ORA-01704: string literal too long
hrcu1.asp, line 17
Am sending the details below for u'r reference
Regards
Sagarika
My D/B str is
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' "
Ora.ExecuteSQL strSql
%>
> 4000 Charecters
