What are the various types of parameter modes in a procedure ?

What are the different types of parameter modes available in plsql procedures ? Thank you for the answer in advance.

more ▼

asked Jan 11, 2010 at 12:00 PM in Default

avatar image

1.3k 82 88 92

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Parameters can be of type: IN - read only OUT - write - no initial value, value must be supplied by procedure INOUT - read/write - new value should be supplied by procedure

Additionally you can specify NOCOPY, which means the compiler "might" (to quote the documentation) pass by reference rather than by value.


(The SHAKEITALLABOUT mode was considered, but rejected :-) )

more ▼

answered Jan 11, 2010 at 01:28 PM

avatar image

Andrew Mobbs
1.6k 3 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 11, 2010 at 12:00 PM

Seen: 3533 times

Last Updated: Jan 11, 2010 at 12:00 PM

Copyright 2018 Redgate Software. Privacy Policy