Re: syntax to open and use package.cursor?

[Phil R Lawrence]

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