Message Oracle PCB-00241 - A host variable is required here

ERRORA host variable is required here
CAUSEThe COUNT item in the dynamic SQL statement must be a host variable but is not.
ACTIONUse a host variable in the COUNT item of the dynamic SQL statement.