Re: Error in a very simple Function

Claudiodom wrote:
> FUNCTION CriaTabela RETURN VARCHAR IS
> BEGIN
> CREATE VIEW T_LOTCDA_TEMP AS SELECT * FROM T_LOTCDA;
>
> RETURN 'NOTHING';
> END;
>
> This funct its inside a package, and its giving an error near 'CREATE'
> and i'm not understanting witch error should this be...
>
>
> can someone help me ??

What you are attempting to do is one of the most horrifying examples of "bad practice" I have seen in a long time. In fact it is so bad I have saved your post as a slide to show in class to my students.

What could possibly posses you to think this a proper use of a function?

Witch error indeed.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org