09-17-2009
Hi, I found the following erros in the mail:
SQL*Loader-500: Unable to open file (control_file.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
It seems something wrong with the control file
BR
apenkov
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
Can some one help me in connecting to oracle through unix shell scripts with examples.
Regards
Narayana Gupta (1 Reply)
Discussion started by: guptan
1 Replies
2. Shell Programming and Scripting
hi,
this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
8 Replies
3. Shell Programming and Scripting
I have the following code in my shell script.
. /apps/oracli/xxxxx/xxxx/oraEnv.9.2.0
sqlplus -s $DB_USER/$DB_PWD@$DB_NAME > xx.html <<EOF
I am passing DBuser and DBname from a config file and the password from user.
Config File :
export DB_USER=xxx;
export DB_NAME=xxx;
I am getting... (1 Reply)
Discussion started by: dzyr4tt
1 Replies
4. Shell Programming and Scripting
Hello Gurus,
I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
1 Replies
5. Shell Programming and Scripting
Hi Folks,
Could you please suggest me how to run a shell script on a solaris env without using crontab. I am actually trying to write a shell script which will grep "WORD" in the logfile andd sends a email.Thanks in advance.
Thanks
Sandeep. (3 Replies)
Discussion started by: sandeep anand
3 Replies
6. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
7. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
8. Shell Programming and Scripting
Hi,
I am trying to connect to oracle database (9.2.0.7.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
Shell Sript:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
@/home/count/qry.sql`
echo... (10 Replies)
Discussion started by: fidelis
10 Replies
9. Shell Programming and Scripting
Hi all,
I am a newbie.....am jus trying to connect to oracle thro a script, but not thro giving the username/password@server_name directly like
`$ORACLE_HOME/bin/sqlplus username/password@server_name
In the above line, once it is connected to Oracle, it shud ask me the username and password... (4 Replies)
Discussion started by: kritibalu
4 Replies
10. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies
LEARN ABOUT DEBIAN
sql::translator::parser
SQL::Translator::Parser(3pm) User Contributed Perl Documentation SQL::Translator::Parser(3pm)
NAME
SQL::Translator::Parser - describes how to write a parser
DESCRIPTION
Parser modules that get invoked by SQL::Translator need to implement a single function: parse. This function will be called by the
SQL::Translator instance as $class::parse($tr, $data_as_string), where $tr is a SQL::Translator instance. Other than that, the classes are
free to define any helper functions, or use any design pattern internally that make the most sense.
When the parser has determined what exists, it will communicate the structure to the producer through the SQL::Translator::Schema object.
This object can be retrieved from the translator (the first argument pass to parse) by calling the schema method:
my $schema = $tr->schema;
The Schema object has methods for adding tables, fields, indices, etc. For more information, consult the docs for SQL::Translator::Schema
and its related modules. For examples of how this works, examine the source code for existing SQL::Translator::Parser::* modules.
AUTHORS
Ken Youens-Clark, <kclark@cpan.org<gt>, darren chamberlain <darren@cpan.org>.
SEE ALSO
perl(1), SQL::Translator, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser(3pm)