Hii All,
I'm trying to insert content of a file into clob column but its throwing below error
SP2-0027: Input is too long (> 2499 characters) - line ignored
Being a clob column it must accept more than 2000 characters.??? Please let me know if I've to modify my code. Also I'm aware that this can be accomplished using sqlloader ,but I don't want to use it here as it is a xml file and don't have any specific delimiter.(As the xml file resides on my application server I cant parse it directly without loading into my DB)
Oracle Version Details
SQL> select *
2 from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Unix Flavour
[eid62960] /users/eid62960/work-->uname
SunOS
#!/bin/bash
l_var=`cat $1`
j=0
for k in `cat $1`
do
j=$((j+1))
myarray[$j]=$k
done
sqlplus -s phase35dev/phase35dev@USDV10G << EOFSQL
insert into r_dummy values ('${myarray[*]}') ;
exit;
EOFSQL
Table Structure
SQL> desc r_dummy
Name Null? Type
----------------------------------------- -------- ----------------------------
A CLOB
Please help me.