Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL In and Out parameters

Have Programming Question? Ask it here!
 
 
 


pratap
In and Out parameters
1 Answer(s)      4 years and 11 months ago
Posted in : SQL



Advertisement
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
SQL IN Parameters
SQL IN Parameters       A parameter is a placeholder that accept a user-defined value, whenever... This Example shows you how to use in type parameters. The Tutorial illustrates
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
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
Access web.xml init parameters
Access web.xml init parameters  How to access web.xml init parameters from java code
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
Passing Parameters - JSP-Servlet
to forward the parameters through click of button **/ On this page I have
how to debug parameters in the hibernate query
how to debug parameters in the hibernate query  how to debug parameters in the hibernate query
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. JSP can... for retrieving parameter values by name. Parameters can be passed by using a tag <jsp
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
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
Request Parameters in JSP
Request Parameters in JSP   ... parameters. HttpServletRequest interface is responsible for providing request parameters. Request Parameters are the data sent from client to the server side
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   The code of the program is given below
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... { ServletOutputStream out = res.getOutputStream(); String name
Passing parameters to XSLT style sheets
Passing parameters to XSLT style sheets       Passing parameters to XSLT style sheets... display, The xml and xsl is passed as parameters to the function '
Passing Parameters using <jsp: param>
Passing Parameters using <jsp: param>          Request parameters can... a string literal as a value. These parameters are evaluated at request time. 
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
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 Its urgent. Pl help me out
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
&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
SQL database parameters should save at where?
SQL database parameters should save at where?  Hi, Currently the information regarding the SQL databases are hard coded into the script, Assuming... parameters to the file and read using JAVA I/O and allow user to edit the file
JSP Out Object
JSP Out Object  JSP Out Object?   out object denotes... of the object out is jsp.JspWriter. The out object "Javax.servlet.jsp.JspWriter". Methods of out Object: clear() clearBuffer() flush() isAutoFlush() getBufferSize
with out class - Java Beginners
with out class  can we write a program with out a class in core java?if yes,give example
How can I get the full URL with the attached parameters? - JSP-Servlet
How can I get the full URL with the attached parameters?  Hi, I'm trying to figure out how to get the current url and use it in my jsp page. I... parameters. For example if the url of the JSP page is: http://localhost
drawing out of bounds
drawing out of bounds  How to throw an exception when a rectangle goes out of the boundaries of a JFrame. The program is asking to draw a triangle, and resize it. If the triagle size goes out of the JFrame throw an execption. I
UIWebView Zoom in and out
UIWebView Zoom in and out  Hi, Can anyone give me the example of tap and zoom in and out the pdf loaded on uiwebview?? Thanks
help me out...!!!!
help me out...!!!!  i have to make a project on console based application in java.. so can anyone guide me with some gd ideas that can be implemented
JSp session time out
JSp session time out  Consider a case where we are working on a java application.After few hours of continuous work ,my application gets logged out... it gets logged out in the middle i.e during our work....why is it so
Out Of Memory Exception Erorr
Out Of Memory Exception Erorr  hello how are you?I hope you are fine I'm using jgrasp program my problem is in java programming my program compiled with no problem but when I run it this exception appears: Exception
Please help me out
Please help me out    Description* You are hired to develop a laptop inventory information system for Sheridan College in order to keep track of the information about the laptops lent to the students. Users can add or remove data
SQL Out Parameter
SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data value ... from SQL Out Parameter .In this Example we create a procedure 'abc
write a program to demonstrate call by value and call by reference.(pass objects as parameters)
write a program to demonstrate call by value and call by reference.(pass objects as parameters)  write a program to demonstrate call by value and call by reference.(pass objects as parameters
how can we pass parameters from jsp href to another servlet
how can we pass parameters from jsp href to another servlet  how can we pass parameters from jsp href to another servlet
not picking request parameters from the front end - JSP-Servlet
not picking request parameters from the front end  hi, This is venkatramana. I am writing one small basic program. I am not getting proper output... welcometo Unicel:" +name; res.setContentType("text/html"); PrintWriter out
Find out last character of array
Find out last character of array  How we can find out the last character of array in java program
Validate operational parameters of application server to support the enterprise application
Validate operational parameters of application server to support the enterprise application Prev Chapter ...; Validate operational parameters of application server to support the enterprise
Passing Parameters to Another JSP Page
Passing Parameters to Another JSP Page      By using the include action we can pass the parameters to another jsp page. We can do this by doing using the <jsp:param>. This tag is used
JavaScript Zoom in and Zoom out
illustrates you how to zoom in and zoom out of an image using JavaScript. Here we... and width of the image and make it to show the effect Zoom In and Zoom Out... the image zoom in and zoom out. As long as you put the cursor on the link Zoom
Java Swing code for zoom in and out
Java Swing code for zoom in and out  hi.......... I require a code in java swing for image zoom in and zoom out can u tell me how it can be done or what is the code plz help
 

 

 

DMCA.com