Subject RE: [firebird-support] Re: In Firebird can you tell when a Stored procedure has been compiled
Author Edward Mendez
Post date 2014-12-20T15:31:23Z

Mark,

 

Thank you, I kind of figured that.

 

Maybe I should have elaborated on my situation. I was given a FB Database and I need to verify if any of the stored procedures have been compiled/changed after a certain date. From what I can gather from the RDB$ tables, it looks like this is not feasible. But I needed to make sure.

 

Thanks,

 

Edward Mendez

 

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, December 19, 2014 2:18 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: In Firebird can you tell when a Stored procedure has been compiled

 

 

On Thu, 18 Dec 2014 18:28:56 -0500, "'Edward Mendez' Emendez001@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> Can you tell in Firebird 2.1.x or 2.5.x when a stored procedure has been
> compiled?

It is "compiled" (to BLR) at the moment you execute the CREATE, ALTER,
CREATE OR ALTER or RECREATE statement.

Mark