Just reference the function name.


CREATE OR REPLACE FUNCTION TEST_FUNCTION
RETURN VARCHAR2
is
begin
return 'test';
end;
/

Function created.

SQL> SELECT TEST_FUNCTION FROM DUAL;

TEST_FUNCTION
------------------------------------------------------------------------
--------

test



-----Original Message-----
From: Sarita Janjani [mailto:[Email Address Removed]
Sent: Friday, January 31, 2003 5:58 AM
To: LazyDBA.com Discussion
Subject: execute function


Hi,
How to execute a function with OUT variables??
Thanks..

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page