Message-ID: <3A50619A.A48700B1@intersystemsww.com>
Date: Mon, 01 Jan 2001 12:53:14 +0200
From: Avi Abrami <aabrami@intersystemsww.com>
Organization: Intersystems
X-Mailer: Mozilla 4.73 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to show result of a function call?
References: <3A4F971F.AFD81C2A@yahoo.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: rev-addr--2054.isdn.net.il
X-Trace: 1 Jan 2001 12:54:40 +0200, rev-addr--2054.isdn.net.il
Lines: 26


Daniel wrote:

> I'm writing some oracle functions and want to call them and display the
> result.
> Is there an easy way to do this in oracle?  Up to this point I've
> written a little pl/sql routine to do it where I declare a bind
> variable, assign it to the function result, and print the variable, but
> would like a simpler way, like a 1-line select statement. Any
> suggestions?
>
> Thanks,
> Daniel
>
> --
> To reply to me directly, please remove "ANTISPAM" from the reply-to
> email address.

Hi Daniel,
Have you tried ...

    SELECT my_function() FROM dual;

HTH,
Avi.