--- title: "getRef Method (java.lang.String) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual apiname: - "SQLServerCallableStatement.getRef (java.lang.String)" apilocation: - "sqljdbc.jar" apitype: "Assembly" ms.assetid: a8ff2dd5-923b-4a2f-ab33-665574b2dfda author: David-Engel ms.author: v-daenge --- # getRef Method (java.lang.String) [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] Retrieves the value of the designated parameter as a Ref object in the Java programming language given the parameter name. ## Syntax ``` public java.sql.Ref getRef(java.lang.String sCol) ``` #### Parameters *sCol* A **String** that contains the parameter name. ## Return Value A Ref object. ## Exceptions [SQLServerException](../../../connect/jdbc/reference/sqlserverexception-class.md) ## Remarks This getRef method is specified by the getRef method in the java.sql.CallableStatement interface. ## See Also [getRef Method (SQLServerCallableStatement)](../../../connect/jdbc/reference/getref-method-sqlservercallablestatement.md) [SQLServerCallableStatement Members](../../../connect/jdbc/reference/sqlservercallablestatement-members.md) [SQLServerCallableStatement Class](../../../connect/jdbc/reference/sqlservercallablestatement-class.md)