-
Perl- sqlplus script
Hi all,
I've been using DBI and Oracle DBD since two years. But at the moment I would like to use perl using sqlplus interface to connect to database for doing backups.
Has any one used perl script for connecting to oracle database like a Bourne shell script. My problem is to connect as sysdba to do some backup tasks on database that is not possible at the moment. The following is the example for Bourne shell script and I would like to change to perl script of some reasons:
#!/bin/sh
ORACLE_HOME=/opt/apps/oracle/product/8.1.5
CONNECT_STRING="$ORACLE_HOME/bin/sqlplus /noLog"
$CONNECT_STRING <
connect / as sysdba
....
...
..
EOF
I would like to write same kind of script in perl like:
#!/usr/bin/perl
...
print <
...
..
EOF
Has any one doing such kind of scripts.
Regards
Hamhey
is not functioning.\
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|