Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Rules and guidelines for stored procedures

Rules and guidelines for stored procedures

Consider the following rules and guidelines for stored procedures:
  • When you use the same column names in the source table as in the table used in the stored procedure, the mapping task fails.
  • When you specify the numeric data type, for example,
    numeric(10,2)
    for a column in a stored procedure, the mapping task fails.
  • When you create a stored procedure in a mapping, the output port must not include the refcursor data type.
  • You cannot read from multiple stored procedures that have the same name even if the input parameters that you specify for the stored procedures are different.