09-07-2009
Yes,
I have a huge log file i want to store it into the Oracle Database using unix shell script.
Log file is siting in unix file server,
pick that file and prepare clob (as we do in java callableStatement.setBinaryStream) and send to oracle stored procedure to insert that clob in CLOB data type field.
Thanks
Rajesh
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am facing problem while accesing FTP related commands in nawk code in bourne shell programming.I can able to connect to remote machine, but i can't able to get files from that machine.
Please help me in this.If you send code along with the solution, then it will be usefull for me. (4 Replies)
Discussion started by: nrsekhar
4 Replies
2. UNIX for Dummies Questions & Answers
Trying to get through UNIX class that I mostly missed due to illness. If anyone can help me with this question I'd appreciate it. Thank you.
How are the following two commands related?
1s -1R /proc
ps ax (1 Reply)
Discussion started by: radhanuja
1 Replies
3. UNIX for Dummies Questions & Answers
I am using rsync for my backing up my files, from one box to other box,
While doing I am getting following error.
arb821/Server/logs/rpcMetrics/
arb821/Server/logs/AribaOrderTransmitterLog.txt
write failed on arb821/Server/logs/AribaOrderTransmitterLog.txt : Error 0
rsync error: error in... (2 Replies)
Discussion started by: redlotus72
2 Replies
4. Forum Support Area for Unregistered Users & Account Problems
How to post a new thread (Regarding Unix related doubts) in Unix Forums.
I registered my id but I am unable to post my Questions to Forum.
Thanks & Regards,
indusri (1 Reply)
Discussion started by: indusri
1 Replies
5. Solaris
Hello Gurus
I would like to know more about ndd commands related to ethernet(NIC) like how to set link_status, link_speed & link_mode as I know how to check these value. And I also would like to know how to make these setting permanents after reboot as I know that these setting will vanish... (5 Replies)
Discussion started by: amity
5 Replies
6. Fedora
Ok, I gotta ask this question, I have just begun fundamentals of UNIX in college and have learned or heard that Mac's OS-X is a linux based os! Does this mean that unix shell commands work in OS-X? I have no experience with os-x yet. I know it's a stupid question but I gotta know! (10 Replies)
Discussion started by: boarder428
10 Replies
7. Solaris
Hi Experts,
In my system cluster is installed and the related files are inside /usr/cluster. I want to use the man page of command which are related to cluster.
The man pages related to cluster are inside /usr/cluster/man, however I am not sure how can I read the man page for command ... (4 Replies)
Discussion started by: kumarmani
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am new to unix , I was planning to write a script that will FTP files to destination folder. , Please guide me what are the various networking commands that unix will help in this ftp process..?:confused: (1 Reply)
Discussion started by: rahul125
1 Replies
9. Solaris
Hi everyone,
I'm new with solaris administration. I have just discovered the notion of METADEVICE and I really don't understand it. Can any one please explain it to me or give me useful link ?
I also want to know more about these commandes:
metainit
metadb
metaattach
Thank you
... (1 Reply)
Discussion started by: adilyos
1 Replies
10. Shell Programming and Scripting
Hi All,
I am trying to dowmload the zip file "zkManageCustomers.zip " but i dont have access. Can anyone help me to download this file
See the below link-
http://www.ibm.com/developerworks/opensource/library/wa-aj-open/index.html?ca=drs-
Please help me as early as... (1 Reply)
Discussion started by: aish11
1 Replies
LEARN ABOUT PHP
cubrid_lob2_import
CUBRID_LOB2_IMPORT(3) 1 CUBRID_LOB2_IMPORT(3)
cubrid_lob2_import - Import BLOB/CLOB data from a file.
SYNOPSIS
bool cubrid_lob2_import (resource $lob_identifier, string $file_name)
DESCRIPTION
The cubrid_lob2_import(3) function is used to save the contents of BLOB/CLOB data from a file. To use this function, you must use
cubrid_lob2_new(3) or fetch a lob object from CUBRID database first. If the file already exists, the operation will fail. This function
will not influence the cursor position of the lob object. It operates the entire lob object.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $filename
-File name you want to import BLOB/CLOB data. It also supports the path of the file.
RETURN VALUES
TRUE if the process is successful and FALSE for failure.
EXAMPLES
Example #1
cubrid_lob2_export(3) example
<?php
$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 (?, ?)");
cubrid_bind($req, 1, 1);
$lob = cubrid_lob2_new($conn, "clob");
cubrid_lob2_import($lob, "doc_1.txt");
cubrid_lob2_bind($req, 2, $lob, 'CLOB'); // or cubrid_lob2_bind($req, 2, $lob);
cubrid_execute($req);
cubrid_lob2_close($lob);
cubrid_disconnect($conn);
?>
SEE ALSO
cubrid_lob2_new(3), cubrid_lob2_close(3), cubrid_lob2_export(3), cubrid_lob2_bind(3).
PHP Documentation Group CUBRID_LOB2_IMPORT(3)