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)

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:

Current Time: Tue May 28 06:09:28 CDT 2024