Sponsored Content
Full Discussion: Problem with SQL loader
Top Forums UNIX for Dummies Questions & Answers Problem with SQL loader Post 302143549 by risshanth on Friday 2nd of November 2007 01:34:08 AM
Old 11-02-2007
Question 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

SQL loader error

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

A SQL Loader Script

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

SQL*Loader in shellscript

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

sql loader script

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

Problem in sql loader

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

SQL*Loader

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

use of sql loader in the script

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

Help Command in SQL LOADER

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

Issue in SQL Loader scripts

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

Call SQL LOADER FROM UNIX

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
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)
All times are GMT -4. The time now is 04:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy