The latest articles on DEV Community by Smart003 (@smart003). https://dev.to/smart003 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F948294%2Fa9a48afc-c219-42c6-8a49-f19e6d4b19f8.png https://dev.to/smart003 en Smart003 Tue, 18 Oct 2022 17:00:02 +0000 https://dev.to/smart003/unable-to-execute-the-block-5g78 https://dev.to/smart003/unable-to-execute-the-block-5g78 <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <div class="ltag__stackexchange--header"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7Gn-iPj_--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/74114607/unable-to-execute-the-block" rel="noopener noreferrer"> unable to execute the block </a> </div> <div class="ltag__stackexchange--post-metadata"> <span>Oct 18 '22</span> <span>Comments: 1</span> <span>Answers: 0</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/74114607/unable-to-execute-the-block" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Y9mJpuJP--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--wif5Zq3z--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>can you help me in rectifying the following code</p> <pre><code>execute immediate $$ declare TABLE_CATALOG varchar default ('DB') TABLE_SCHEMA varchar default ('SCH'); VIEW_NAME varchar default ('View'); VEW resultset default (SELECT * from table(GET_OBJECT_REFERENCES(DATABASE_NAME =&gt;:TABLE_CATALOG , SCHEMA_NAME =&gt;:TABLE_SCHEMA, OBJECT_NAME =&gt;:VIEW_NAME))); begin return table(VEW); end; $$ ; </code></pre> <p>the following error appears when the…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/74114607/unable-to-execute-the-block" class="ltag__stackexchange--btn" rel="noopener noreferrer">Open Full Question</a> </div> </div> snowflake sql beginners database