How to create a stored procedure in sqlserver to return value by taking input parameter

Hi
   Creating dynamic stored proceudre to return value by taking input parameter.

CREATE OR REPLACE PROCEDURE
UP_SELECTSP (
selColName IN VARCHAR, --selColName is used for selecting single column or multiple columns
TableName IN VARCHAR, --TableName is used for providing Table Name
whrCondition IN VARCHAR, --whrCondition is used for provide where condition
getResult_Cur OUT SYS_REFCURSOR --getResult_Cur is used for returning result set
)
AS
strSQL varchar(1000);
BEGIN
IF whrCondition is not null then

strSQL := 'SELECT ' || selColName || '
FROM ' || TableName || '
WHERE ' || whrCondition || ''; 

ELSE
strSQL := 'SELECT ' || selColName || '
FROM ' || TableName || '';
END IF;

OPEN getResult_Cur FOR strSQL;

END UP_SELECTSP;

Create Procedure Sp_Name
(
@para1 datatype,
@para2 Datatype out
)
As
Begin
Set @para2=(value)
End