Re: simple questions

From: aquabubble <aquabubble_at_geocities.com>
Date: Mon, 15 Nov 1999 11:12:50 GMT
Message-ID: <80oprg$qc9$1@nnrp1.deja.com>

In article <80ol4b$4c0$1_at_news.hk.linkage.net>, "Alan Sze" <alan_at_icon.com.hk> wrote:
>
> Hi, all,
>
> I would have a few simple questions to ask.
> How to call a function within a pl/sql package in SQLPlus ??
> and how to display the return value??
>
> I've used
> call package_a.function_a('para A', 'para B', 0, 'para C', 'para
D');
> but it said
> *
> Error in line 1:
> ORA-00904: Invalid column name.

You could use:

SELECT package_a.function_a('para A', 'para B', 0, 'para C', 'para D') FROM dual;

HTH Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 15 1999 - 05:12:50 CST