How to write SQL function in SQL script

[deep_215]

Hi,

I am trying to write a SQL function in SQL script

CREATE OR REPLACE FUNCTION fun1() RETURNS VOID AS

DECLARE
VAR_VALUE INTEGER;
e RECORD;
BEGIN
for e in select col1,col2 from table
Loop
--BODY OF FUNCTION
END LOOP;
END; 

I am getting error while running the code in DECLARE section stating unexpected <EOF>.

Can anyone help me to get rid of this issue and help me in executing the SQL Script for SQL function.

Thanks in advance.

Regards,

Deepak

[Turribeach]

What SQL engine do you use?

[deep_215]

I am using Snowflake

[Turribeach]

And it's that how you create a SQL function in Snowflake? (ie the correct syntax):

https://docs.snowflake.com/en/developer-guide/udf/sql/udf-sql-introduction

It looks like you copied the syntax from this documentation page which is showing how to create a function in PL/pgSQL which is PostgreSQL Procedural languange.  

Each SQL engine has it's own SQL syntax, it's own SQL procedural language, etc. You can't mix and match.