You have to declare a variable in sqlplus and then say
variable := package_name.function_name(parameterlist);
Alan Sze wrote in message <80ol4b$4c0$1_at_news.hk.linkage.net>...
>
>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.
>
>Thanks.
>
>-- Alan
>
>
>
>
Received on Mon Nov 15 1999 - 04:14:46 CST
