On 6/27/07, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote:
> You can hand the procedure name in question to that query and if you
> receive a result, then a procedure with the same name exists in the
> database.
Maybe it's better to try to run it and catch exception. You will save
one trip to DB. If exist.
> I would be aware of the danger that the procedure could probably have
> the same name, but maybe it has a different content/effect from the
> one you wish to implement/recreate.
>
> In addition I think I remember that only with classic server engine a
> listed stored proc is active already for the next connection to the
> database.
What do you mean with listed?
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
