Perl quoting Problem doing select on Oracle.

[Kalin Evtimov]

IT Works!

I don't know why, but it looks like this:

select value from v\\\$\parameter where name = 'background_dump_dest';

after half a day testing I found it.

[Oviwan]

nice :)

other solution. if you have installed the dbi module you could use this code:

#!/usr/bin/perl -w

use DBI;
$connection = DBI->connect("DBI:Oracle:DBNAME","USERNAME", "PASSWORD");
$query = $connection->prepare("select value from v\$parameter where name = 'background_dump_dest'");
$query->execute();
while (@result=$query->fetchrow_array) {
print "$result[0]\n";
}
$connection->disconnect();

[Kalin Evtimov]

Yeah, but I don't know whether DBI-Module is on all systems. Except this I am logging in without having to type password etc..