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: Bind Variables in a Procedure

Re: Bind Variables in a Procedure

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/25
Message-ID: <32EA3252.5474@qrcsun.qrc.org>#1/1

Jeff Davidson wrote:
>
> Can someone help me with this procedure? I want to be able to say
>
> SQL>EXEC PKEY('CLIENT');
  You can declare a variable such as cname

  VARIABLE cname VARCHAR2;

  Then EXEC :cname := PKEY('CLIENT');

  Finally, PRINT cname to print the return result.

---
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 Sat Jan 25 1997 - 00:00:00 CST

Original text of this message

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