Re: pl/sql question

From: James Peterson <james.peterson_at_teldta.com>
Date: 1996/06/14
Message-ID: <4ps1gp$42m_at_news2.tds.net>#1/1

Hi,

You could populate a variable by passing that variable to a procedure as an OUT parameter. This conceals the assignment operation, but of course you ultimately make a conventional assignment using the := operator.

declare
  myvar number := 0;
  myval number := 3;

  procedure myproc (passedvar out myvar%type,

                    passedval in myval%type)

  as
  begin
    passedvar := passedval;
  end;

begin
  dbms_output.put_line('Myvar = '||myvar);   myproc(myvar,myval);
  dbms_output.put_line('Myvar = '||myvar); end;
/

Jim

-- 

StarCrusher <abukhari_at_vpcc.sunysb.edu> wrote:


>Hi all,


>

>Here's a quick question regarding pl/sql:

>

>Is it possible to assign values in pl/sql without using   :=    

>perhaps an assignment setting function of some sort.

>

>Thanx,

>Ali

>abukhari_at_vpcc.sunysb.edu

=============================

Jim Peterson
TDS Computing Services
Madison, WI USA
james.peterson_at_teldta.com

Received on Fri Jun 14 1996 - 00:00:00 CEST