You should be able to simply use the function in the SQL within your Perl
script. For example :
my $sth = $dbh->prepare(q(
SELECT my_func(raw_data)
FROM my_table
));
etc
If you can use the function in SQL*Plus, you can use it with Perl/DBI.
HTH,
Steve
> -----Original Message-----
> From: Riccardo Bonuccelli [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 6 September 2006 6:37 PM
> To: [email protected]
> Subject: DBI custom functions
>
> Hello there,
>
> I must retrieve a particular field from an Oracle DB with perl/DBI. This
> field is actually formatted as a kind of bytestring and I developed an
> oracle function to retrieve that field in a correct way, but as I told I
> have to connect through DBI.
>
> So the question is:
> Is there a way to define custom functions to be used in a dbi session?
>
> Thanks in advance.
>
> --
> Riccardo
> http://www.flickr.com/photos/askthepixel
