Returns the number of times a character expression occurs within another character expression.
cSearchExpression -- Specifies a character expression that OCCURS( ) searches for within cExpressionSearched.
cExpressionSearched -- Specifies the character expression OCCURS( ) searches for cSearchExpression.
OCCURS( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.