How can you pass parameter and get the data back from the procedure?

There are options to pass parameters and get back values from the procedure:

IN:

This is the Default Parameter which is passed to procedure. It always receives the values from the calling program. In the procedure we can set a default value for this parameter as well, in case it will be passed as null as it will take the default value

OUT:

This parameter sends back the values to the calling program.

IN OUT:

This parameter performs both the operations. It Receives value from as well as sends the values to the calling program.