Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Oracle only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Member List
Calendar
Today's Posts
Home
Forum
Topic
Oracle
Pl/sql
Pl/sql
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
jenni
New Member
Join Date:
Dec 2007
Posts:
10
#1
Pl/sql
Dec 29 '07, 03:27 PM
When OUT and IN OUT parameter are used in function in PL/SQL?
Please tell the situation in which it is used?
amitpatel66
Recognized Expert
Top Contributor
Join Date:
Mar 2007
Posts:
2358
#2
Dec 31 '07, 04:35 AM
Originally posted by
jenni
When OUT and IN OUT parameter are used in function in PL/SQL?
Please tell the situation in which it is used?
Using of OUT and IN OUT parameters in FUNCTIONS is a POOR PROGRAMMING PRACTICE. A Function should reutrn only one value and not more than that!!
Use procedure instead!!
Comment
Post
Cancel
debasisdas
Recognized Expert
Expert
Join Date:
Dec 2006
Posts:
8119
#3
Dec 31 '07, 04:53 AM
Please find the details of the parameters
here
.
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
👍
👎
☕
Comment