use Oracle commands inside perl script with SSH

[charith]

Hi All'

I need a execute oracle command on remote db server using perl and I try with following but it not work. Can any one Suggest way to do this without using DBI or any module.

my $memp = qx{ssh -o stricthostkeychecking=no  $db_hosts "sqlplus -s $db_string<<EOF
                show parameter memory;
                exit 
                EOF"};

Thanks

[atreyu]

I'm more of a MySQL person, so I'm not familiar with sqlplus. but I know that with mysql there is a way to pass a command to a MySQL instance and then exit (using the -e parameter). e.g., this command will show all databases on my MySQL server:

mysql -u db_user -e 'show databases'

armed with that, I could then do this, from a shell:

/usr/bin/ssh $db_host "mysql -u db_user -e 'show databases'"

and then in a Perl script, I could do something like:

system("/usr/bin/ssh $db_host \"mysql -e 'show databases'\"");

or if you wanted to capture the output to a variable:

my $out = `/usr/bin/ssh $db_host "mysql -e 'show databases'"`;
print "$out\n";

So check the documentation/man pages, etc. for sqlplus and see if anything like that is available.

[Cabhan]

I'm confused. Why wouldn't you want to use a module? That's exactly what they're designed for.
DBD::Oracle - search.cpan.org

[charith]

Thank you very much for quick reply.

I'm confused. Why wouldn't you want to use a module? That's exactly what they're designed for.
DBD::Oracle - search.cpan.org

I need to run this script on client side.so I can't depend on any modules.

[Cabhan]

I guess I would still ask why you can't. Presumably your script will be installed somehow on the client's machine: why can't the module be as well? Or why not just distribute them together?

Although sqlplus can probably get so far as "Execute a command", it's going to be very difficult to parse its output (hell, sqlplus is hard enough to use when you're using it the way it was intended, let alone using it a different way), or to do anything within the context of a transaction, or anything like this.

[charith]

Thanks Cabhan;


Finally I realized that without module can't be survive..,so can you please explain how can I used this module with my script.I mean How I create one package with module to send client.