11-02-2007
Problem with SQL loader
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 string not properly terminated
What could be the reason ??
Follwoing is my .ctl file:
OPTIONS ( SKIP=1)
LOAD DATA
INFILE './matched.txt'
BADFILE './matched.bad'
DISCARDFILE './matched.dsc'
INTO TABLE "DATA"
APPEND
FIELDS TERMINATED BY X'9'
TRAILING NULLCOLS
(RECORD_ID "TRIM(:RECORD_ID)"
,
MATCH_LEVEL "TRIM(:MATCH_LEVEL)"
,
MATCH_IDENTIFIER "TRIM(:MATCH_IDENTIFIER)"
,
TDLINX "TRIM(:TDLINX)"
,
STORE_NAME "TRIM(:STORE_NAME)"
,
STORE_ADDRESS "TRIM(:STORE_ADDRESS)"
,
STORE_CITY "TRIM(:STORE_CITY)"
,
STORE_STATE "TRIM(:STORE_STATE)"
,
STORE_ZIP "TRIM(:STORE_ZIP)"
,
PHONE_NUMBER "TRIM(:PHONE_NUMBER)"
,
STATUS "'I'"
,
DATE_CREATED "SYSDATE"
,
USER_CREATED_BY "SYSTEM"
)
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
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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. Shell Programming and Scripting
Hi,
I'm planning to load the data from FLAT files into tables.
Source file: more input.txt
LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity|... (6 Replies)
Discussion started by: shyamu544
6 Replies
10. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LEARN ABOUT DEBIAN
catalyst::plugin::configloader::manual
Catalyst::Plugin::ConfigLoader::Manual(3pm) User Contributed Perl Documentation Catalyst::Plugin::ConfigLoader::Manual(3pm)
NAME
Catalyst::Plugin::ConfigLoader::Manual - Guide to using the ConfigLoader plugin
BASIC USAGE
package MyApp;
use Catalyst qw( ConfigLoader ... );
ENVIRONMENT VARIABLES
o "MYAPP_CONFIG" - specific config file to load for "MyApp"
o "CATALYST_CONFIG_LOCAL_SUFFIX" - global suffix for extra config files
o "MYAPP_CONFIG_LOCAL_SUFFIX" - suffix specifically for "MyApp"
CONFIG FORMATS
Config::General
Extensions
o cnf
o conf
Example Config
name = TestApp
<Component Controller::Foo>
foo bar
</Component>
<Model Baz>
qux xyzzy
</Model>
INI
Extensions
o ini
Example Config
name=TestApp
[Controller::Foo]
foo=bar
[Model::Baz]
qux=xyzzy
JSON
Extensions
o jsn
o json
Example Config
{
"name": "TestApp",
"Controller::Foo": {
"foo": "bar"
},
"Model::Baz": {
"qux": "xyzzy"
}
}
Perl
Extensions
o pl
o perl
Example Config
{
name => 'TestApp',
'Controller::Foo' => {
foo => 'bar'
},
'Model::Baz' => {
qux => 'xyzzy'
}
}
XML
Extensions
o xml
Example Config
<config>
<name>MyApp::CMS</name>
<paths>
<upload_dir>/var/www/docs/myapp-cms/uploads</upload_dir>
</paths>
<model name="DB">
<connect_info>dbi:mysql:cmsdb</connect_info>
<connect_info>user</connect_info>
<connect_info>password</connect_info>
</model>
<component name="View::TT">
<INCLUDE_PATH>__path_to(root,templates)__</INCLUDE_PATH>
<ENCODING>UTF-8</ENCODING>
<TRIM>1</TRIM>
<PRE_CHOMP>2</PRE_CHOMP>
<POST_CHOMP>2</POST_CHOMP>
</component>
</config>
Note that the name attribute for the "model" tag should be the relative namespace of the Catalyst model, not the absolute one. That is for
"MyApp::Model::Something" the "name" attribute should be "Something".
YAML
Extensions
o yml
o yaml
Example Config
---
name: TestApp
Controller::Foo:
foo: bar
Model::Baz:
qux: xyzzy
COOKBOOK
Configuring a Catalyst::Model::DBIC::Schema model from a YAML config
Model::MyModel:
schema_class: MyApp::MySchema
connect_info:
- dbi:SQLite:myapp.db
- ''
- ''
- AutoCommit: 1
Converting your existing config to Config::General format
As of Catalyst::Devel 1.07, a newly created application will use Config::General for configuration. If you wish to convert your existing
config, run the following one-liner (replacing MyApp with your app's name):
perl -Ilib -MMyApp -MConfig::General -e 'Config::General->new->save_file("myapp.conf", MyApp->config);'
Using UTF-8 strings in a Config::General file
If you have UTF-8 strings in your Config::General-based config file, you should add the following config information to MyApp.pm:
__PACKAGE__->config( 'Plugin::ConfigLoader' => {
driver => {
'General' => { -UTF8 => 1 },
}
} );
Using a local configuration file
When ConfigLoader reads configurations, it starts by reading the configuration file for "myapp" with one of the supported extensions as
listed above.
For example, A Config::General config file is "myapp.conf".
If a configuration file called "myapp_local" exists with one of the supported file extensions, it will also be read, and values from that
file will override values from the main config file.
A Config::General local configuration file would be called "myapp_local.conf".
The "local" suffix can be changed. See "get_config_local_suffix" in Catalyst::Plugin::ConfigLoader for the details of how.
This is useful because it allows different people or environments to have different configuration files. A project with three developers,
Tom, Dick, and Harry as well as a production environment can have a "myapp_tom.conf", a "myapp_dick.conf", a "myapp_harry.conf", and a
"myapp_production.conf".
Each developer, and the web server, would set the environment variable to load their proper configuration file. All of the configurations
can be stored properly in source control.
If there is no "myapp_local.ext" (where .ext is a supported extension), and the individual configuration files contain something required
to start the application, such as the Model's data source definition, the applicaton won't start unless the environment variable is set
properly.
perl v5.14.2 2010-03-23 Catalyst::Plugin::ConfigLoader::Manual(3pm)