HI, How to call Oracle stored procedure in perl...
Pls let me know simple example.... Regards, Srini. -----Original Message----- From: Phil R Lawrence [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 8:44 AM To: [EMAIL PROTECTED] Subject: Re: syntax to open and use package.cursor? Hi, Can anyone help me with this question? I want to use a stored cursor from DBI... My (failed) attempt is below. Thanks! Phil R Lawrence wrote: > With Oracle 8, > > I tried: > > my $open_cursor = $dbh->prepare( qq{ > BEGIN > OPEN p_lu_ar_bal.c_lu_tbraccd_rowid( ? ); > END; > } ); > > $open_cursor->execute( '12-MAY-2003' ); > > while (my $rowid = $open_cursor->fetchrow_array) { > print $rowid, "\n"; > } > > result: > DBD::Oracle::st fetchrow_array failed: ERROR no statement executing (perhaps you need to call execute first) > > Here is the procedure: > CREATE OR REPLACE PACKAGE p_lu_ar_bal AS > ... > CURSOR c_lu_tbraccd_rowid (as_of_date DATE) > IS > SELECT TBRACCD_ROWID > FROM > ( > ... > ); > ... > > Can someone help my syntax? > > Thanks, > prl
