Hydrolyzes the second messenger cAMP, which is a key regulator of many important physiological processes. May be involved in the control of cAMP-mediated neural activity and cAMP metabolism in the brain.