Hi,
I didn't test this yet, but i think firebird should not allow you execute ddl
inside stored procedures, even using an "execute statement". Just like a commit.
Isn't that right?

Valdir.

----- Original Message -----
From: "Michael Vilhelmsen" <Michael.Vilhelmsen@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, December 03, 2003 8:15 AM
Subject: [firebird-support] Re: Trigger and drop procedure


> So do I.
>
> So they can't delete these specific things unless noone is connected
> to the DB except themselves.
>
> Michael
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> >
> > > > Only with Firebird 1.5 if you use EXECUTE STATEMENT.
> > > >
> > > > The question is: why?
> > >
> > > Because I have some user independent tables with procedure and
> > > generator attached. Thats why !
> >
> > Hmmm... most people, including me, dislike the idea of adding/
> > modifying metadata while people are connected, or as a part of
> > the application.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - developer tool for InterBase, Firebird, MySQL
> & MS SQL
> > Server.
> > Upscene Productions
> > http://www.upscene.com
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>