One small correction, you can specify NOCOPY for OUT and IN OUT parameters.

Regards,

Sandeep S. Gondhalekar
Patni Computer Systems Ltd.
Unit No. 62, SDF II, SEEPZ,
Andheri (E), MUMBAI.
Tel: 8291454 Ext.: 5249

-----Original Message-----
From: Sandeep G [SMTP:sandeep.[Email Address Removed] Thursday, August 30, 2001 9:19 PM
To: LazyDBA.com Discussion
Subject: RE: call store procedure ( pass by value and pass by reference)

Hi Sonny,

In PL/SQL, by default parameters of type IN are passed by ref. and OUT and
IN OUT are passed by value. In 8i, you can change the behaviour by
specifyng NOCOPY for IN and IN OUT parameters to pass by ref. But you can't
specify NOCOPY for IN parameter because it is default nature of IN
parameter.

Regards,

Sandeep S. Gondhalekar
Patni Computer Systems Ltd.
Unit No. 62, SDF II, SEEPZ,
Andheri (E), MUMBAI.
Tel: 8291454 Ext.: 5249

-----Original Message-----
From: Kajornkiattikun, Sonny [SMTP:[Email Address Removed] Friday, August 31, 2001 9:15 AM
To: LazyDBA.com Discussion
Subject: call store procedure ( pass by value and pass by reference)

Dear Gurus


In C program , I call function by pass by value or pass by
reference

How can I do In PL/SQL to call store procedure by pass by reference?

Thanks in Advance
Sonny


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page