In and Out parameters

In and Out parameters

View Answers

September 22, 2009 at 3:24 PM

Hi Friend,

Stored Procedures are basically used for passing values and receiving values.It is having three parameters-IN,OUT,INOUT.

1)IN: It is default parameter which is passed to the procedure and can change inside the procedure, but remains unchanged outside.

2)OUT: This parameter does not supply any value to the procedure.It is assumed to be NULL, but it can be modified inside the procedure, and is available outside the procedure.

Try this to add two numbers:

DELIMITER $$
CREATE PROCEDURE pr3(IN in_count INT,IN in1_count INT)
BEGIN
DECLARE num INT;
SET num =in_count + in1_count;
SELECT num;
END$$
call pr3(5,5);

Thanks









Related Tutorials/Questions & Answers:
In and Out parameters - SQL
In and Out parameters  What are in and out parameters in stored... parameters-IN,OUT,INOUT. 1)IN: It is default parameter which is passed... no's and get output using parameters in MySql  Hi Friend, Stored Procedures
supplying values to in parameters of stored procedure in ms sql and displaying out parameters
supplying values to in parameters of stored procedure in ms sql and displaying out parameters  I have to execute following procedure ALTER PROCEDURE [dbo].[get_date] @codeId int, @vardate as datetime OUTPUT AS SELECT
Advertisements
How do I find out the number of parameters passed into function9. ?
How do I find out the number of parameters passed into function9. ?  How do I find out the number of parameters passed into function9
error:Parameter index out of range (1 > number of parameters, which is 0).
error:Parameter index out of range (1 > number of parameters, which is 0).  my code:String org=request.getParameter("Org"); String desg=request.getParameter("des"); String From=request.getParameter("From"); String
the number of parameters
the number of parameters  How do I find out the number of parameters passed into function
named parameters vs postional parameters - Hibernate
named parameters vs postional parameters  hi,Can you please explain why we i should go for particular parameters or positional parameter... regards, somasekhar
SQL IN Parameters
SQL IN Parameters       A parameter is a placeholder that accept a user-defined value, whenever..._TO_REPLACE_1 This Example shows you how to use in type parameters. The Tutorial
ModuleNotFoundError: No module named 'parameters'
ModuleNotFoundError: No module named 'parameters'  Hi, My Python... 'parameters' How to remove the ModuleNotFoundError: No module named 'parameters' error? Thanks   Hi, In your python environment you
Access web.xml init parameters
Access web.xml init parameters  How to access web.xml init parameters from java code
measuring Qos parameters
measuring Qos parameters   Hi, is there a tool for measuring the quality of service (Qos) of an web services. Thanks
measuring Qos parameters
measuring Qos parameters   Hi, is there a tool for measuring the quality of service (Qos) of an web services. Thanks
JSP-parameters possible ways
JSP-parameters possible ways  In a JSP program called books.jsp, the Java code out.print(request.getParameter(â??numberâ??)); displays â??1111111â??. What are the ways for the parameter number to have got its value
JSP-parameters possible ways
JSP-parameters possible ways  In a JSP program called books.jsp, the Java code out.print(request.getParameter(â??numberâ??)); displays â??1111111â??. What are the ways for the parameter number to have got its value
parameters - JSP-Servlet
example with sending parameters with hyperlibk in srevlets to jsp.. Thanqs advnce
how to debug parameters in the hibernate query
how to debug parameters in the hibernate query  how to debug parameters in the hibernate query
Passing Parameters - JSP-Servlet
to forward the parameters through click of button **/ On this page I have
ModuleNotFoundError: No module named 'inasafe-parameters'
ModuleNotFoundError: No module named 'inasafe-parameters'  Hi, My... named 'inasafe-parameters' How to remove the ModuleNotFoundError: No module named 'inasafe-parameters' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'parameters-validation'
ModuleNotFoundError: No module named 'parameters-validation'  Hi...: No module named 'parameters-validation' How to remove the ModuleNotFoundError: No module named 'parameters-validation' error? Thanks   Hi
ModuleNotFoundError: No module named 'simple-parameters'
ModuleNotFoundError: No module named 'simple-parameters'  Hi, My... named 'simple-parameters' How to remove the ModuleNotFoundError: No module named 'simple-parameters' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'sleep-parameters'
ModuleNotFoundError: No module named 'sleep-parameters'  Hi, My... named 'sleep-parameters' How to remove the ModuleNotFoundError: No module named 'sleep-parameters' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'static_parameters'
ModuleNotFoundError: No module named 'static_parameters'  Hi, My... named 'static_parameters' How to remove the ModuleNotFoundError: No module named 'static_parameters' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'validate-parameters'
ModuleNotFoundError: No module named 'validate-parameters'  Hi, My... named 'validate-parameters' How to remove the ModuleNotFoundError: No module named 'validate-parameters' error? Thanks   Hi
ModuleNotFoundError: No module named 'hexia-parameters'
ModuleNotFoundError: No module named 'hexia-parameters'  Hi, My... named 'hexia-parameters' How to remove the ModuleNotFoundError: No module named 'hexia-parameters' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'inasafe-parameters'
ModuleNotFoundError: No module named 'inasafe-parameters'  Hi, My... named 'inasafe-parameters' How to remove the ModuleNotFoundError: No module named 'inasafe-parameters' error? Thanks   Hi, In your
log out
log out  how do i create a log out on a project without it exiting system so it does not reload again
Is there anyone out there?
Is there anyone out there?  Hi please could somebody respond as I am seeking advice but not getting any and do not know whether or not to continue using this site
Explain the parameters of Font class constructor.
Explain the parameters of Font class constructor.  Explain the parameters of Font class constructor.   Java Font class: Font(String name... and point size. Parameters: name - the font name. This can be a logical font name
Passing parameters in JSP using forward.
Passing parameters in JSP using forward.  If a page is forwarded to another page using jsp:forward, is it necessary that the page should be already............   Pass Parameters using jsp:forward
Passing Parameters in jsp
Passing Parameters in jsp       This section illustrates you how to pass parameters in jsp.ADS...() method for retrieving parameter values by name. Parameters can be passed by using
url parameters displayed in short sentence
url parameters displayed in short sentence  In my url parmeter like below http://127.0.0.1:7778/project/preview.jsp.codesvr=127.0.0.1:9997&id="1" It will displayed the value of id=1 ... I want to change this url
java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!
java.lang.IndexOutOfBoundsException: Remember that ordinal parameters...: java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based! Full error: java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based
Request Parameters in JSP
Request Parameters in JSP   ... for providing request parameters. Request Parameters are the data sent from client... bgcolor="white"> <h1> Request Parameters </h2> <
ModuleNotFoundError: No module named 'django-add-get-parameters'
ModuleNotFoundError: No module named 'django-add-get-parameters'  Hi...: No module named 'django-add-get-parameters' How to remove the ModuleNotFoundError: No module named 'django-add-get-parameters' error? Thanks  
ModuleNotFoundError: No module named 'django-add-get-parameters'
ModuleNotFoundError: No module named 'django-add-get-parameters'  Hi...: No module named 'django-add-get-parameters' How to remove the ModuleNotFoundError: No module named 'django-add-get-parameters' error? Thanks  
ModuleNotFoundError: No module named 'django-site-parameters'
ModuleNotFoundError: No module named 'django-site-parameters'  Hi...: No module named 'django-site-parameters' How to remove the ModuleNotFoundError: No module named 'django-site-parameters' error? Thanks   Hi
ModuleNotFoundError: No module named 'pytest-report-parameters'
ModuleNotFoundError: No module named 'pytest-report-parameters'  Hi...: No module named 'pytest-report-parameters' How to remove the ModuleNotFoundError: No module named 'pytest-report-parameters' error? Thanks  
ModuleNotFoundError: No module named 'scrapy-job-parameters'
ModuleNotFoundError: No module named 'scrapy-job-parameters'  Hi...: No module named 'scrapy-job-parameters' How to remove the ModuleNotFoundError: No module named 'scrapy-job-parameters' error? Thanks   Hi
ModuleNotFoundError: No module named 'aws-parameters-store'
ModuleNotFoundError: No module named 'aws-parameters-store'  Hi...: No module named 'aws-parameters-store' How to remove the ModuleNotFoundError: No module named 'aws-parameters-store' error? Thanks   Hi
ModuleNotFoundError: No module named 'django-add-get-parameters'
ModuleNotFoundError: No module named 'django-add-get-parameters'  Hi...: No module named 'django-add-get-parameters' How to remove the ModuleNotFoundError: No module named 'django-add-get-parameters' error? Thanks  
ModuleNotFoundError: No module named 'django-query-parameters'
ModuleNotFoundError: No module named 'django-query-parameters'  Hi...: No module named 'django-query-parameters' How to remove the ModuleNotFoundError: No module named 'django-query-parameters' error? Thanks   
ModuleNotFoundError: No module named 'django-site-parameters'
ModuleNotFoundError: No module named 'django-site-parameters'  Hi...: No module named 'django-site-parameters' How to remove the ModuleNotFoundError: No module named 'django-site-parameters' error? Thanks   Hi
Applet Tag Parameters,Applet Tag in HTML
<APPLET> Tag Parameters: The <PARAM> Tag       These are the parameters passed directly to a Java applet. Parameters are to applets what command-line
Request Parameters In EL
Request Parameters In EL     ... to read the parameters from the file. If we have multiple values to read from... to retrieve the parameters in EL  ADS_TO_REPLACE_1 The code of the program
Passing parameters to XSLT style sheets
Passing parameters to XSLT style sheets       Passing parameters to XSLT style sheets.... After setting display, The xml and xsl is passed as parameters
Passing Parameters using <jsp: param>
Passing Parameters using <jsp: param>          Request parameters can... name and takes a string literal as a value. These parameters are evaluated
Can anybody tell me how to use #parameters in struts 2 ?
Can anybody tell me how to use #parameters in struts 2 ?  I have a login page, And by using struts.xml and #parameters I want to display error.../Login.jsp ADS_TO_REPLACE_1 Its urgent. Pl help me out
Pass parameters from JSP to Servlet
Pass parameters from JSP to Servlet In this section, you will learn how to pass parameters from JSP page to servlet. For this purpose, we have used...) throws IOException { ServletOutputStream out = res.getOutputStream(); String name
&lt;APPLET&gt; Tag Parameters: The &lt;PARAM&gt; Tag
<APPLET> Tag Parameters: The <PARAM> Tag       These are the parameters passed directly to a Java applet. Parameters are to applets what command-line
Velocity Macro with Parameters
Velocity Macro with Parameters       This Example shows you how to use macro with parameters in velocity  template. Example given below show you, how
org.openrndr.extra - orx-parameters-js version 0.4.0-rc.4 Maven dependency. How to use orx-parameters-js version 0.4.0-rc.4 in pom.xml?
org.openrndr.extra  - Version 0.4.0-rc.4 of orx-parameters-js Maven...-parameters-js in pom.xml? How to use orx-parameters-js version 0.4.0-rc.4... org.openrndr.extra  - Version 0.4.0-rc.4 of orx-parameters-js in project

Ads