stored-procedures - Redshift 过程返回表给出错误

Question

我在 Redshift 中创建了以下程序。但是在调用它时出现错误：

程序：

CREATE OR REPLACE PROCEDURE  schema_check(schemaName IN VARCHAR, rs_out INOUT refcursor)
AS $$
BEGIN

    WITH tmp_variables AS (
    select t.table_schema,
           t.table_name,
           c.column_name,
           c.data_type       
    from information_schema.tables t
    inner join information_schema.columns c 
               on c.table_name = t.table_name 
               and c.table_schema = t.table_schema
    where t.table_schema ILIKE schemaName
          and t.table_type = 'BASE TABLE'
    order by t.table_schema
    );
   
   OPEN rs_out FOR  select * from tmp_variables;
END;
$$ LANGUAGE plpgsql;

错误：

An error occurred when executing the SQL command:
CALL schema_check('pg_catalog','test')

[Amazon](500310) Invalid operation: syntax error at end of input;

我试图寻找这个，但最终什么也没有。请帮忙。谢谢

标签： stored-proceduresamazon-redshiftplpgsql