Parameter Type Mappings

For details about the type attribute for <parameter> elements. The supported types are mapped as follows:

<parameter> type	Oracle type	SQL server type
text	VARCHAR2	NVARCHAR()
numeric (long)	NUMBER	BIGINT
numeric (short)	PLS_INTEGER	INT
date	DATE	DATETIME
date_range (2 parameters passed)	DATE	DATETIME
checkbox	PLS_INTEGER	BIT
list	PLS_INTEGER	INT
choice	PLS_INTEGER	INT
systemid	NUMBER	BIGINT
real	FLOAT	REAL