1 Answer
- Newest
- Most votes
- Most comments
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,
Relevant content
- asked 5 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 10 months ago