Home » SQL & PL/SQL » SQL & PL/SQL » Re: creating a view within a function
Re: creating a view within a function [message #36069] Fri, 02 November 2001 06:15
Richard Quintin
Messages: 1
Registered: November 2001
Junior Member
What problem are you having? Are you getting an error message?

Andrew - the error message you are referring to can be fixed by granting create view privilege to the user executing the function. (It can't be granted in a role -- has to be done explicitly)

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: usage of temporary table in pl/sql procedure
Next Topic: Creating a new table based on the info from old table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 27 13:05:58 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.