Hello Everyone,
I'm attempting to design a small web app to obtain customer feedback.
The issue is when a user inputs >4000 characters in the COMMENTS
section I get the following Err Msg: ORA-01704: string literal too
long.
I am using Visual Studio.Net 2003 (vb as language), SQL+ to create
tables in Oracle 9i, and Access to just link and veiw the tables.
Used SQL+ to create the table
sql> create table tab1
(NAME varchar2(100), COMMENTS CLOB);
My webform has 2 textboxes, 1 button and 1 label
Code looks like so:
Imports System.Data
Imports System.Data.Ole DB
_______________ __________
Private ConnectString as String
....
ConnectString = "Yada, Yada, Yada..."
....
Dim con As New OleDBConnection (ConnectString)
_______________ _______________ __
The following is my input statement:
Private Sub btnSubmit_Click .........
TRY
Dim insertSQL, Name, Comments As String
Dim Added as Integer
NAME = " ' " & txtName.text & " ' "
COMMENTS = " ' " & txtComments.tex t & " ' "
insertSQL = "INSERT INTO TAB1(NAME, COMMENTS)" & _
"VALUES (" & NAME & ", " & COMMENTS & ")"
DIM cmd As New OleDBCommand(in sertSQL, con)
con,open()
added = cmd.ExecuteNonQ uery
con.close()
'gives me some kind of confirmation record was submitted
If added > 0 Then
lblErr.text = "Record Submitted"
End If
Catch ex As Exception
con.close()
lblErr.text = ex.Message
End Try
End Sub
_______________ _______________ ____________
This is as detailed as I can get. Do I need to declare COMMENTS as
something other than string? Is there some other way I need to write
the insert statement? Am I way off and should hang it up as a beginner
..Net developer? I have read through tons of docs, websites, and groups
and can't come up with any definitive answers. This is my first time
posting. Willing to help anyone and any help would be MUCH appreciated. 1 16217
You can't use oledb, I added the Oracle reference and used Imports
Oracle.DataAcce ss.Client and Oracle.DataAcce ss.Types, I changed some
code around and on day 2 got it working. I would like to post a couple
of links that assisted me in completing my task and hope it well help
others with my same situation. This applies to all LOBs.
'this will go over the setup of tables and code needed to read the
clob, this must be done first, before you can write to a LOB field.
Yes, you have to read before you can write. The link will further
explain. http://www.oracle.com/technology/pub...ns_dotnet.html
'this one will explain how to write to a LOB field http://www.oracle.com/technology/pub...e_dotnet2.html
Thank you all. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Rob Panosh |
last post by:
Hello,
I am having trouble moving data from a CLOB to a NCLOB column.
My current table structure for table fmattachmentembed:
--------------------------------------------------------
fmattachmentid number(10,0) not null,
fmvalue clob null,
fmextension varchar2(4) null,
fmsize number(8,0) null
|
by: Srinadh |
last post by:
Hi all,
We have files with about 20 to 30 fields per row.
We are trying to update such files with about 60 rows as contiguous
data in a CLOB field.
It passes through.
But when we try updating files with about 60 to 200 rows, we get the
|
by: beena |
last post by:
We have a mainframe DB2 table with CLOB data type...
What's the best way to transfer CLOB data from os/390 DB2
to UDB (8.2) on AIX 5.2.
We tried unloading data with fixed format and tried loading in UDB
using Method L.
Unloaded CLOB field seems to have \n which causes confusion with the
row delimitor (\n)...
|
by: jens Jensen |
last post by:
Hello,
I got this "breath taking" task to write a an http server to which "xml
data" will be posted to and will answer with xml data.
The logic behind the xml processing is not a matter here.
My question is : Can i configure a webservice for HHTP POST ?
The remote peer just performs an http web request.
NO RPC style call to my system.
|
by: egarobar |
last post by:
I am using Access 2003 (on WinXP) to read from an Oracle db, where there is a table with a CLOB which is a variable-size text field. In the 'linked table' which is created in the Tables panel of Access, the CLOB becomes a Memo field. I need to create a report that displays the data from this CLOB in the correct format. The data in the CLOB contains any number of chr(13), i.e. Carriage Returns, without LF, to separate lines of data that are...
| |
by: Peter Kanurer |
last post by:
Assume I add in VisualCSharp 2005 References to
Oracle.DataAccess
AND
System.Data.OracleClient
to an application. Does this cause problems or can they co-exist in one application ?
|
by: avimel |
last post by:
I have a CLOB generated by a call to DBMS_XMLGEN.NEWCONTEXT('SELECT ...') which contains data that needs to be parsed and output to file one row at a time; the row data in the CLOB is delimited by </ROW></ROW> pairs.
v_xml_clob CLOB;
--I use two offset pointers to indicate each row of data:
v_start NUMBER(10);
v_end NUMBER(10);
|
by: pai |
last post by:
Hi All,
I have a field which had a field of DATA TYPE CLOB and in that
I have inserted an XML.
How can I see the contents of that XML file.
Please Help
Regards
Pai
|
by: Vinodsrvk |
last post by:
I tried to execute the bellow query for the word "about" in the NARRATIVE field.
This narrative field is of CLOB type with NOTNULL
SELECT SEARCHID, NARRATIVE
FROM S.TBLSEARCH
WHERE CONTAINS(NARRATIVE, 'about') >0
/
|
by: kcanterbury |
last post by:
I am trying to insert a CLOB data field (1M in size) into an Oracle table using a COBOL DB/2 program. I have an alius in DB2 set up for the Oracle table. The field is defined as TYPE is CLOB(1M) in both the DCLGEN and the Working Storage Copybook. However, I keep receiving a -311 SQLCode saying that the size is inconsistent. Do I need a size parameter as in VARCHAR?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |