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,