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.\