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.