RE: Problem with closing bound cursors

2003-12-01 Thread Fox, Michael
Dave, Not real sure; you seem to have done it as per the examples in the doco ( I just use bind_param for the close cursor, not bind_param_inout. And I use it with a stored procedure, as in: $sql = "BEGIN dwh_util.ref_cursor_close(:curref); END;"; $sth = $dbh->prepare($sql); $st

Re: Problem with closing bound cursors

2003-12-01 Thread Andy Hassall
Dave Bloom wrote: > > I have been trying to close bound cursors for a week now > and am completely at a loss. No matter what I do I get: > > > DBD::Oracle::st execute failed: ORA-01001: invalid cursor > > ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /tmp/test line > 36. > > I've followed