On the Effectiveness of Large Language Models in Automating Categorization of Scientific Texts