SELECT 
P.ENABLED, 
P.CMSMETADATACLASSID, 
P.CMSMETADATAPROPERTYID, 
P.DESCRIPTION, 
P.DISPLAYNAME, 
P.NAME 
INTO
:enabled, 
:cmsMetadataClassID, 
:cmsMetadataPropertyID, 
:description, 
:displayName, 
:name 
FROM CMSMETADATAPROPERTY P, CMSMETADATACLASS C 
WHERE 
P.CMSMETADATACLASSID = C.CMSMETADATACLASSID AND
C.NAME = :name