Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: simple questions
The SELECT .... FROM dual doesn't work for me... How to declare a variable in sqlplus so that I can use var_a := package_a.function_a(....) ???
Thanks again..
aquabubble <aquabubble_at_geocities.com> wrote in message
news:80oprg$qc9$1_at_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 - 06:45:39 CST