Automatic Smart Contract Generation Through LLMs: When The Stochastic Parrot Fails