473,508 Members | 2,053 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Difference between In and Out parameters in Oracle functions

1 New Member
Hi,

Can someone tell me exact difference between In and Out parameters used while creating a function in Oracle?

Thanks in advance.
Jan 4 '13 #1
2 1961
sainathsagar
7 New Member
IN -- Value is used in a program.
It cannot be a variable but could be literal,expression,value.

OUT -- Value is returned back from the program to the caller.
It must be a variable.

IN OUT-- It is combination of IN and OUT as name resembles.
It acts like a variable i.e., value can be used in
the program and then it can be returned back to the
caller from the program.
Jan 4 '13 #2
arumurali
20 New Member
IN parameters are passed as constants from the calling environment into the procedure.

OUT parameter values are returned from procedure to the calling environment.
Mar 14 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
7215
by: Roger Redford | last post by:
Dear Experts, I'm attempting to marry a system to an Oracle 817 datbase. Oracle is my specialty, the back end mainly, so I don't know much about java or javascript. The system uses javascript...
4
13788
by: VIKAS17786 | last post by:
COULD YOU EXPLAIN ME WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ........................... ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? ..... I...
3
5585
by: Greg Copeland | last post by:
I'm using SQLAlchemy and have a need to call an Oracle function; which is not the same as a stored procedure. Can this be done directory or indirectly with SQLAlchemy? If so, can someone please...
0
1029
by: Rajeev Kumar Sarawagi | last post by:
Can anyone say that the difference between oracle and informix
6
6714
Inbaraj
by: Inbaraj | last post by:
Hi.... Can any one say me the difference between the Oracle 9i and 10g. I was asked this question in the interview can any one say me the difference.... Thanks in advance... with reg...
3
6897
by: barrathi | last post by:
Hai all, can you explain DIFFERENCE BETWEEN ORACLE 9I AND ORACLE 10G? thanks in advance.
3
11263
by: sank | last post by:
Hi, I want to know the difference between oracle 9i and 10g. thanks and regards sankar
1
1668
by: RPPORTER | last post by:
I am a newbie to Oracle functions and need help with a function. I am trying to create a report to show only those accounts/customers with an activity date/invoice date from January 1, 2007 to the...
1
2088
by: sakthidevi | last post by:
Hi all, Please help me...... difference between oracle 9i and sqlserver 2008...
0
7326
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7385
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7046
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7498
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5629
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5053
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4707
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3195
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
418
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.