ORA-01756 Error while inserting a file in CLOB field
Hi,
Please guide me where i am doing wrong, i am getting ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
Please tell me the correct sample script.
Thanks
Raj
Last edited by Scott; 07-12-2010 at 06:59 AM..
Reason: Code tags, please...
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Hello,
Hoping someone can help!
I have a file (fileA) with a potentially different number of | delimited fields the file looks like:
fileA
A|B|C|D|E|F|G|
A|B|C|D|E|F|G|
This file could have 100+ fields and have 2million+ records
I have another file (fileB) which contains an 8 digit... (3 Replies)
I have a '|' delimited file.
My file looks like below
23|nationalhoilday|feb12||||||||||||||california|northdistrict||
In the same way, each record has 164 fields. I have to insert one more field after the 85th field.
Expected output... (3 Replies)
Hello Mates,
I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434
Out put should be:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434
Can some one help me to... (8 Replies)
I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number.
As an example, let's assume there are only 4 fields in the file:
A,A,,32
A,A,,27
A,B,,43
C,C,,354
If I wanted to amend the 3rd field in this way my... (2 Replies)
Hi all,
I am reading control file log from my server and putting it to a variable
for j in $(cat $dirname/ctl_file.log)
do
if
then
Y=${#fileclob_ctl_file}
if
then
fileclob_ctl_file=$j
else
fileclob_ctl_file="${fileclob_ctl_file},${j}"
fi
fi
... (5 Replies)
Hi All,
I have the input as below:
cat input
032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies
LEARN ABOUT PHP
cubrid_lob2_write
CUBRID_LOB2_WRITE(3) 1 CUBRID_LOB2_WRITE(3)cubrid_lob2_write - Write to a lob object.SYNOPSIS
bool cubrid_lob2_write (resource $lob_identifier, string $buf)
DESCRIPTION
The cubrid_lob2_write(3) function reads as much as data from $buf and stores it to the LOB object. Note that this function can only append
characters now.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $buf
-Data that need to be written to the lob object.
RETURN VALUES
TRUE if the process is successful and FALSE for failure.
EXAMPLES
Example #1
cubrid_lob2_write(3) example 1
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES(2, ?)");
$lob = cubrid_lob2_new($conn, 'CLOB');
$len = cubrid_lob2_write($lob, "Hello world");
cubrid_lob2_bind($req, 1, $lob);
cubrid_execute($req);
cubrid_disconnect($conn);
?>
Example #2
cubrid_lob2_write(3) example 2
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
cubrid_execute($conn,"DROP TABLE if exists test_lob");
cubrid_execute($conn,"CREATE TABLE test_lob (id INT, contents CLOB)");
$req = cubrid_prepare($conn, "INSERT INTO test_lob VALUES(1, ?)");
$lob1 = cubrid_lob2_new($conn, 'CLOB');
$len = cubrid_lob2_write($lob1, "cubrid php driver");
cubrid_lob2_bind($req, 1, $lob1);
cubrid_execute($req);
$req = cubrid_execute($conn, "select * from test_lob");
$row = cubrid_fetch_row($req, CUBRID_LOB);
$lob2 = $row[1];
cubrid_lob2_seek($lob2, 0, CUBRID_CURSOR_LAST);
$pos = cubrid_lob2_tell($lob2);
print "pos before write: $pos
";
cubrid_lob2_write($lob2, "Hello world");
$pos = cubrid_lob2_tell($lob2);
print "pos after write: $pos
";
cubrid_disconnect($conn);
?>
SEE ALSO cubrid_lob2_read(3), cubrid_lob2_seek(3), cubrid_lob2_seek64(3), cubrid_lob2_tell(3), cubrid_lob2_tell64(3), cubrid_lob2_size(3),
cubrid_lob2_size64(3).
PHP Documentation Group CUBRID_LOB2_WRITE(3)