Hi All,
I have a stored procedure as like this..
procedure example
is
cursor html_cur
is
select a, b from html_bill ;
a varchar2(20);
b varchar2(20);
BEGIN
NULL;
END;
The table html_bill contains 5 records.
am using a perl script like below to invoke the stored procedure.
use Oraperl;
my ($sth, $stmt,$SQL, $return);
$dbh=
DBI->connect('dbi:Oracle:host=hostname;sid=net','test','test');
$SQL = "BEGIN example; END;";
$func= $dbh->prepare($SQL);
$rv = $func->execute;
print "No of rows = " . $func->rows() . "\n";
while(@data=$func->fetchrow_array){
print "@data\n";
}
if ( $@ ) {
warn " Execution of stored procedure failed:
$DBI::errstr\n";
$dbh->rollback();
}
print "Excution of stored procedure returned $rv\n";
$dbh->disconnect();
It says Number of rows as 1 and am not able to fetch the selected
rows(it says some error).
Any idea how to manipulate the selected rows.
Senthil Kumar
3rd Floor,27,Whites Rd
ph # 044 - 8529917/8526917 x : 3791
This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information.If you are not
the intended recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or
copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
