Sponsored Content
Top Forums Shell Programming and Scripting Perl script to load data by calling sqlldr Post 302510985 by pravin27 on Tuesday 5th of April 2011 12:13:07 PM
Old 04-05-2011
Try using full path of sqlldr. /oraclehome/bin/sqlldr
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

2. Web Development

script to load data from csv file

hello i want a script to load the data line by line from a csv file into a mysql table (3 Replies)
Discussion started by: srpa01red
3 Replies

3. Shell Programming and Scripting

Calling 3 perl script from one

hi all, I have 3 perl scripts a.pl,b.pl and c.pl each of these work when i pass a date for eg: perl c.pl 2010-05-27 now i want to write a perl script that would call the 3 scripts and make it run all the 3 scripts (a.pl,b.pl,c.pl) parallelly rather than 1 after the other....... pls... (2 Replies)
Discussion started by: siva_nagarajan
2 Replies

4. Shell Programming and Scripting

Shell script to find specific file name and load data

I need help as to how to write a script in Unix for the following: We have 3 servers; The mainframe will FTP them to a folder. In that folder we will need the script to look and see if the specific file name is there and load it to the correct table. Can anyone pls help me out with... (2 Replies)
Discussion started by: msrahman
2 Replies

5. Shell Programming and Scripting

Perl script to Archive the data file after the load

I have written a perl scripts which loads the data. Now i want to modify the script, to Archive the Input file after the successful load of data. Can anyone please share it and help me .... Thanks. (2 Replies)
Discussion started by: msrahman
2 Replies

6. Homework & Coursework Questions

Shell script calling Perl function, sort and find data, write to new files

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and... (6 Replies)
Discussion started by: kowit010
6 Replies

7. Shell Programming and Scripting

calling a perl script with arguments from a parent perl script

I am trying to run a perl script which needs input arguments from a parent perl script, but doesn't seem to work. Appreciate your help in this regard. From parent.pl $input1=123; $input2=abc; I tried calling it with system("/usr/bin/perl child.pl $input1 $input2"); and `perl... (1 Reply)
Discussion started by: grajp002
1 Replies

8. Shell Programming and Scripting

How to read file and load data into a script as variable

I need to read a text file that contain columns of data, i need to read 1st column as a function to call, and others are the data i need to get into a ksh script. I am quite new to ksh scripting, i am not very sure how to read each row line by line and the data in each columns of that line, set... (3 Replies)
Discussion started by: gavin_L
3 Replies

9. Shell Programming and Scripting

Parallel sqlldr to load data.

I am using SQLLDR to load data in DB.For parallel loading I'm using nohup command. The requirement is: I have different files within a directories. Ex: 1) Dir/folder_A/AE.txt 2) Dir/folder_A/DM.txt 3) Dir/folder_B/CM.txt I need to loop through directories and load the data... (1 Reply)
Discussion started by: Pratiksha Mehra
1 Replies

10. Shell Programming and Scripting

SQLLDR :Data not loaded completely

Hi , I am using below control file LOAD DATA APPEND INTO TABLE LSHADMIN.EG TRAILING NULLCOLS ( STUDY CHAR ) and the text file to load data is CACZ885M2301 When I run below command: sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
Debian::DpkgLists(3pm)					User Contributed Perl Documentation				    Debian::DpkgLists(3pm)

NAME
Debian::DpkgLists - scan /var/lib/dpkg/info/*.list for files/patterns SYNOPSIS
my @packages = Debian::DpkgLists->scan_full_path('/full/file/path'); my @packages = Debian::DpkgLists->scan_partial_path('file/path'); my @packages = Debian::DpkgLists->scan_pattern(qr{freedom$}); my @packages = Debian::DpkgLists->scan_perl_mod('Some::Module'); DESCRIPTION
Debian::DpkgLists is a module for easy searching of dpkg(1)'s package file lists. These are located in /var/lib/dpkg/info/*.list and contain a simple list of full file names (including the leading slash). There are a couple of different class methods for searching by full or partial path, a regular expression or a Perl module name. Note that dpkg's file lists represent only dpkg's idea of what is installed on the system. If you want to also search in packages, available from the Debian archive but not installed locally, see Debian::AptContents. CLASS-METHODS scan_full_path ( path ) Scans dpkg file lists for files, whose full path is equal to path. Use when you have the full path of the file you want, like "/usr/bin/perl". Returns a (possibly empty) list of packages containing path. scan_partial_path ( path ) Scans dpkg file lists for files, whose full path ends with path. Use when you only care about the file name or other trailing portion of the full path like "bin/perl" (matches "/usr/bin/perl" and "/sbin/perl"). Returns a (possibly empty) list of packages containing files whose full path ends with path. scan_pattern ( pattern ) Scans dpkg file lists for files, whose full path matched pattern. Returns a (possibly empty) list of packages containing files whose full path matches pattern. scan_perl_mod ( Module::Name ) Scans dpkg file lists for files, corresponding to given Module::Name. This is a shorthand method for "scan_pattern" with a pattern that matches "/Module/Name.pm$" in all directories in @INC. Returns a (possibly empty) list of packages containing possible Module::Name files. AUTHOR
Damyan Ivanov <dmn@debian.org> COPYRIGHT &; LICENSE Copyright (C) 2010 Damyan Ivanov <dmn@debian.org> This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. perl v5.14.2 2012-01-15 Debian::DpkgLists(3pm)
All times are GMT -4. The time now is 08:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy