syntax to open and use package.cursor?

[Phil R Lawrence]

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