Subject Re: [firebird-php] SP Locked
Author Helen Borrie
At 04:59 AM 24/11/2004 -0800, you wrote:

>I am using a Creole driver (written by me) to connect to a Firebird
>database and call SPs.
>The sequence of operations is the following (via the driver classes):
>ibase_pconnect to the DB
>ibase_prepare a query for calling the SP
>ibase_execute with the query parameters
>navigate the result set
>However, when subsequently trying to edit the called SP from the
>Firebird client, the client issues a warning saying that the SP is in
>Since I am closing everything I used, I do not know where the problem
>originates. Might there be some default started transactions that must
>be closed or smth like this? Is it something in the interbase PHP

Not this time. <g> When a SP runs, Firebird caches it. Because it is
cached, it is "in use". Releasing depends on which server model you are
using. For Classic, simply logging out and logging in again should release
it and you will be able to submit your RECREATE or ALTER request. On
Superserver, everybody must log out, and then the SP will be released when
the first user logs back in.