Re: Calling a PostgreSQL function via DBI

Thank you Greg,
I allready solf it. First I changed the code this way:
my $arg1 = $cookieValue . "::numeric";
my $arg2 = $suchprofil_name . "::text";

$result = $dbh->prepare ( "SELECT neues_suchprofil ( $arg1, '$arg2' ) " ) or
die "Vorbereitung nicht durchfuehrbar!\n";
$result->execute() or die "Abfrage nicht ausfuehrbar -suchprofil!
$DBI::errstr\n";
$result->finish();

And then I grand some priviliges on the user, which access the DBI. Now it
works :-)

Gruss Christian

--
DSL-Aktion wegen großer Nachfrage bis 28.2.2006 verlängert:
GMX DSL-Flatrate 1 Jahr kostenlos* http://www.gmx.net/de/go/dsl
.

Relevant Pages

  • Re: W Commutes Libbys Sentence
    ... A man drink like that and he don't eat, he is going to DIE, The Grand ... Beckoning! ...
    (rec.sport.football.college)
  • Re: Terrible accident
    ... I only want to pay a grand for it, ... <fails to die in stampede of vendors> ...
    (uk.rec.driving)