11-12-2012
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i am getting the following error when i am using sql loader.
SQL*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach
ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies
2. Shell Programming and Scripting
I am a novice Unix scripter and need a little advice/help on a script I've written that's causing some problems. We are using Solaris 9 on a Sun box and the script is invoked with the korn shell. I have a two-part question: I wrote a shell script that calls and executes 3 separate sql scripts,... (3 Replies)
Discussion started by: E2004
3 Replies
3. Shell Programming and Scripting
Hi Guys,
I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically.
Let me break it down a bit more,... (2 Replies)
Discussion started by: LiquidChild
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am trying to load the records in a .txt file into the data base using SQL loader. I gave:
$ sqlldr user/pass@DB control=filename.ctl log =mylog.log
It throwed the following error:
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS.
ORA-01756: quoted... (2 Replies)
Discussion started by: risshanth
2 Replies
5. Shell Programming and Scripting
Hi,
what is the ideal format of the file to load it into oracle table by using SQL*LOADER. The file contains six columns and the oracle table contains 15 columns. Is there any criteria that columns should be equal in no.?
Can anyone help me on this, i need to use this in my shell script?
... (2 Replies)
Discussion started by: venkatesht
2 Replies
6. Shell Programming and Scripting
hi all
i am new to shell scripting.
i have 35 flat files delimited files that i have to load in to a table.
i was asked to create a shell script that loads the data into the table...
could you please help me if you have a script.
Also .. how to create logs files...does my sql... (3 Replies)
Discussion started by: rajesh_tns
3 Replies
7. Shell Programming and Scripting
Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file... (3 Replies)
Discussion started by: Gopal_Engg
3 Replies
8. UNIX for Dummies Questions & Answers
HI Experts,
We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows.
print "LOAD DATA" > $WEDB_GEN/ldrscan.ctl
print "INFILE '"$LED_SCAN"/delta/led_del.dat'" >> $WEDB_GEN/ldrparms.ctl
print "TRUNCATE" >> $WEDB_GEN/ldrscan.ctl
print "PRESERVE BLANKS" >>... (1 Reply)
Discussion started by: ajaykumarkona
1 Replies
9. Shell Programming and Scripting
All,
Below is the code written when sql loader loads the data:
$ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER
ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000
rc=$?... (1 Reply)
Discussion started by: Oracle_User
1 Replies
10. UNIX for Dummies Questions & Answers
Which is the UNIX command to get the SQL Loader Help??:confused: (1 Reply)
Discussion started by: venkatesh sunil
1 Replies
LEARN ABOUT DEBIAN
net::google::code::issue
Net::Google::Code::Issue(3pm) User Contributed Perl Documentation Net::Google::Code::Issue(3pm)
NAME
Net::Google::Code::Issue - Google Code Issue
SYNOPSIS
use Net::Google::Code::Issue;
my $issue = Net::Google::Code::Issue->new( project => 'net-google-code' );
$issue->load(42);
DESCRIPTION
ATTRIBUTES
project
project name
email, password
user's email and password
id
status
owner
reporter
reported
merged
stars
closed
cc
summary
description
labels
comments
attachments
INTERFACE
load
parse
updated
the last comment's date.
create comment, summary, status, owner, cc, labels, files.
update comment, summary, status, owner, merge_into, cc, labels, blocked_on, files.
list( q => '', can => '', author => '', id => '', label => '', max_results => '', owner => '', published_min => '', published_max => '',
updated_min => '', updated_max => '', start_index => '' )
google's api way to get/search issues
return a list of loaded issues in list context, a ref to the list otherwise.
load_comments
google's api way to get and load comments( no scraping is done here )
parse_hybrid
when $USE_HYBRID is true, we will try to load issue with the google's official api, but as the api is not complete, we still need to do
scraping to load something( e.g. attachments ), this method is used to do this.
AUTHOR
sunnavy "<sunnavy@bestpractical.com>"
LICENCE AND COPYRIGHT
Copyright 2008-2010 Best Practical Solutions.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-04-28 Net::Google::Code::Issue(3pm)