Oracle Column type in SP Parameter

  p_FILEEXTENSION   IN    USACCTFLINFO.FILEEXTENSION%type := NULL


SP Parameter Name: p_FILEEXTENSION
Table Name: USACCTFLINFO
Table Column Name: FILEEXTENSION


If you want parameter type as column type then just write above code in SP