Re: Creating a procedure and function HELP

simon_s_li_at_hotmail.com wrote:
> Hi,
>
> Can anyone tell me what the difference with the keyword 'IS' and 'AS'
> when used after the declaration of the procedure of function.
>
> Example:
>
> CREATE OR REPLACE FUNCTION(val VARCHAR) RETURN VARCHAR2 IS
>
> CREATE OR REPLACE FUNCTION(val VARCHAR) RETURN VARCHAR2 AS
>
> When do you use 'IS' and when do you use 'AS'????
>
> Regards
> Simon

'IS' when what follows is PL/SQL, 'AS' when to map a Java or C method name.

HTH -g Received on Thu Mar 16 2006 - 08:22:55 CST