Re: Bind Variables in a Procedure

From: Lun Wing San (Oracle) <"Lun>
Date: 1997/01/25
Message-ID: <32EA3252.5474_at_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 CET

Original text of this message