I'm a little late picking up on this thread, but I do
have a question.
Why are you closing the cursor?
When you disconnect, all your cursors will be closed.
If you aren't disconnecting, the only good reason for
closing a cursor is that you will no longer be using
it during the session, which may
On Wed, 10 Dec 2003 09:30:20 -0500 Ronald J Kimball
<[EMAIL PROTECTED]> wrote:
> On Wed, Dec 10, 2003 at 01:30:30AM -0800, Michael A Chase wrote:
> > On Wed, 10 Dec 2003 10:04:28 +0100 Patrick Kuijvenhoven
> > <[EMAIL PROTECTED]> wrote:
> > $sth3 = $dbh->prepare("BEGIN CLOSE :cursor END");
>
>
On Wed, Dec 10, 2003 at 01:30:30AM -0800, Michael A Chase wrote:
> On Wed, 10 Dec 2003 10:04:28 +0100 Patrick Kuijvenhoven
> <[EMAIL PROTECTED]> wrote:
>
> > I just copy/pasted that syntax from documentation. It should be changed
> > there as well.
>
> The problem is that you __DIDN'T__ copy the
On Wed, 10 Dec 2003 10:04:28 +0100 Patrick Kuijvenhoven
<[EMAIL PROTECTED]> wrote:
> I just copy/pasted that syntax from documentation. It should be changed
> there as well.
The problem is that you __DIDN'T__ copy the example from the documentation.
Here is the exact code from `perldoc DBI::Oracl
On Wed, Dec 10, 2003 at 10:04:28AM +0100, Patrick Kuijvenhoven wrote:
> Hi,
>
> I just copy/pasted that syntax from documentation. It should be changed there as
> well.
>
> I now have the following error:
>
> DBD::Oracle::st execute failed: ORA-01023: Cursor context not found (Invalid cursor
>
You may get a different error, but at least it is now valid PL/SQL
syntax.
Steve
-Original Message-
From: Patrick Kuijvenhoven [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 10 December 2003 7:04 PM
To: [EMAIL PROTECTED]
Subject: RE: (Fwd) RE: DBD::Oracle: closing bound cursors
Still,
or, but at least it is now valid PL/SQL
syntax.
Steve
-Original Message-
From: Patrick Kuijvenhoven [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 10 December 2003 7:04 PM
To: [EMAIL PROTECTED]
Subject: RE: (Fwd) RE: DBD::Oracle: closing bound cursors
Still, no luck. Hoping not to spa
,
Patrick
-Oorspronkelijk bericht-
Van: Fox, Michael [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 9 december 2003 22:30
Aan: [EMAIL PROTECTED]
CC: Patrick Kuijvenhoven
Onderwerp: RE: (Fwd) RE: DBD::Oracle: closing bound cursors
Patrick,
Its all in the documentation now (as in perldoc DBD
Patrick,
Its all in the documentation now (as in perldoc DBD::Oracle), but in case
this doesn't work for you it says:
"
To close the cursor you (currently) need to do this:
$sth3 = $dbh->prepare("BEGIN CLOSE :cursor END");
$sth3->bind_param_inout(":cursor", \$sth2, 0, { ora_type => ORA
