Re: create table from procedure?
From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 2 Jul 2003 13:11:31 +0200
Message-ID: <bduel4$fdq$1_at_news.fujitsu-siemens.com>
Date: Wed, 2 Jul 2003 13:11:31 +0200
Message-ID: <bduel4$fdq$1_at_news.fujitsu-siemens.com>
Volker Hetzer wrote:
> Hi!
> I've got this little testcase where I create a table from a procedure
> and
> and using begin/end in sqlplus.
> Why doesn't the create table work in the procedure too?
Got it. Had to do with definer rights and roles.
Lots of Greetings!
Volker
-- While it is a known fact that programmers never make mistakes, it is still a good idea to humor the users by checking for errors at critical points in your program. -Robert D. Schneider, "Optimizing INFORMIX Applications"Received on Wed Jul 02 2003 - 13:11:31 CEST