client access with perl etc.

From: Rüdiger J. Schulz <r.schulz_at_berlin.de>
Date: Tue, 03 Nov 1998 17:20:30 +0000
Message-ID: <363F3B5E.93A889AE@berlin.de>

is it possible to call a stored procedure from a client like odbc or perl that returns an array
e.g.: perl: ...

$query = "exec sp_xyz($para)"; ### <- this is the
question !!!!!!!!!

$sth = $dbh->prepare($query);
$sth->execute;

              @arr = ($sth->fetchrow_array);
              print $arr[1];
              ...

i want to know how to program the stored procedure "sp_xyz" in oracle ?? Received on Tue Nov 03 1998 - 11:20:30 CST