1 回答
- 最新
- 投票最多
- 评论最多
0
Hi,
Are you trying to create the stored procedure via SQL Workbench/J? If yes, what is the version of the JDBC driver? I have just tried to create the following sample stored procedure via SQL Workbench/J and it was created successfully. Redshift cluster version 1.0.41881 and JDBC 4.2 version 2.1.0.9
CREATE OR REPLACE PROCEDURE test_sp1(f1 int, f2 varchar)
AS $$
BEGIN
RAISE INFO 'f1 = %, f2 = %', f1, f2;
END;
$$ LANGUAGE plpgsql;
Thanks,