I need to insert values into tables. I am doing it using sqlloader. Evrything is going fine, except the columns with CLOB datatype. I am unable to insert them, I am getting an error. This is the code I wrote: -
-
load data
-
infile *
-
insert into table statusof_sites
-
fields terminated by ',' optionally enclosed by '"'
-
Trailing Nullcols
-
(id,
-
dc,
-
df,
-
cid,
-
lob_file FILLER char,
-
csc_configuration LOBFILE(lob_file) TERMINATED BY EOF)
-
-
BEGIN DATA
-
1, hd, gh , ACME, C:\cntrl\xyz.txt
-
-
ERROR:
-
-
LOB_FILE NEXT * , O(") CHARACTER
-
(FILLER FIELD)
-
CSC_CONFIGURATION DERIVED * EOF CHARACTER
-
Dynamic LOBFILE. Filename in field LOB_FILE
-
-
SQL*Loader-460: Column (CSC_CONFIGURATION), form of use (1) does not match char set id of (31)
-
What should I do now? And what should be the data format in infile, if we specify the path externally like
infile 'C:\cntrl\xyz.c tl'
Please help me...
1 9034 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: freak |
last post by:
hi
i have problems reading an oracle(9i) clob from a php-script with the
MDB-class from pear.
the table files has 3 fields:
id integer
document clob
picture clob
|
by: wqhdebian |
last post by:
fils:=bfilename(directory => receiveDir,filename => fileName);
dbms_lob.open(fils,dbms_lob.file_readonly);
dbms_lob.createtemporary(xDoc,true);
---------------- the result is 353
dbms_output.put_line(dbms_lob.getlength(fils));
dbms_lob.loadfromfile(xDoc,fils,dbms_lob.getlength(fils));
-------------- the result is 176
dbms_output.put_line(dbms_lob.getlength(xdoc));
dbms_lob.close(file_loc => fils);
commit;
|
by: Chris |
last post by:
I use websphere connection pooling and had a failure attempting a
CLOB.createTemporary.
tempClob = CLOB.createTemporary(conn, true,
CLOB.DURATION_SESSION);
Here's an excerpt of the exception and stack-trace.
java.lang.ClassCastException:
com.ibm.ejs.cm.proxy.OracleConnectionProxy
at oracle.jdbc.driver.OracleConnection.physicalConnectionWithin
|
by: tachoknight |
last post by:
Hi all-
I have a windows service (like a Unix daemon) that loads flat files
into an 8.1.7 database. I use Oracle Objects for this, but it takes a
very long time, especially with CLOBs to do > 10,000 records. I would
use SQL Loader, but because this is a service, I can't spawn SQLLoader
to do the load for me.
Is there a SQLLoader-type API that I can call to do the same
functionality from within my program?
|
by: abhishek.srivastav |
last post by:
I am a newbie in db2.
We have a table CLOBTAB defined as
CREATE TABLE CLOBTAB(COL CLOB(2M))
We are trying to load a file of around 1 MB into this table using load
command. The file is deos not have a record delimiter as we want this
complete data as one record in the table.
The load command is as follows:
| |
by: gupta.harika |
last post by:
Hi everyone,
I am a developer working on php with oracle as backend.
I am facing a problem related with the CLOB data.
The problem is as follows
My application uses a table which contains Clob datatype.
I need to do a search on this table based on the clob data,i.e., I am
using the column which is a clob datatype in the where clause.
The query is as follows
" select * from mytable where (dbms_lob.instr(mybody, 'as') > 0)"
|
by: msc.batra |
last post by:
I want to load multiple rows of BLOB and CLOB into DB2 using CLI. Which
are the possible ways to do it? Any help...
|
by: sainiamit25 |
last post by:
Hi,
I want to insert 8 lakh records into one table. Table has got around 25 columns. The table has got indexes but before insertion, the indexes are dropped and after the reocrds are run, the indexes are again created. But insertion of these records take around 5- 6 hours. As far as i know, sqlloader should not take this much time. Can anybody tell me what may be the cause of this problem? Is it related to autocommit in sqlloader? Do we need...
|
by: rdudejr |
last post by:
Hi all,
I hardly ever make a post unless I am having a very purplexing issue,
so this one should be good...
I am trying to do a load against a database on an AIX server into a
DB2 v9.1 database, using SAN for storage. The table has a few CLOBs
(smallish clobs but we are storing XML data in non-native format).
Here is the load command I am using:
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |