Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function w/Record Param in SELECT?

Re: Function w/Record Param in SELECT?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/20
Message-ID: <32BB8421.6EE9@qrcsun.qrc.org>#1/1

Barry Johnson wrote:
> Is there a way to short-circuit this with something like?!?:
>
> SELECT Pkg.F( * ) FROM Tbl ;
>

   You cannot do in this way according to the Oracle Manual. It says that stored procedure or function used in SQL statement cannot manipulate whole columns at the same time. It can only support row operations.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Fri Dec 20 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US