Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

SYNTAX_ERROR: line 26:7: Unexpected parameters (varchar) for function substr

0

SELECT T1."PDC_CODE" "c1", substr(cast(T2."RECEIVING_DATE" as varchar)) "c2", sum(T2."QTY_RECEIVED") "c3", T3."SUPPLIER_SOURCE" "c4"

SYNTAX_ERROR: line 26:7: Unexpected parameters (varchar) for function substr. Expected: substr(varchar(x), bigint, bigint) , substr(varchar(x), bigint) , substr(char(x), bigint) , substr(char(x), bigint, bigint) , substr(varbinary, bigint, bigint) , substr(varbinary, bigint)

Topics
.NET on AWSDeveloper Tools
Tags
.NET on AWSDeveloper Tools
Language
English
asked 3 years ago616 views
1 Answer
0

Hello,

A parameter parameter's value is not compatible with the corresponding type. For example: {% if parameters.change_value._parameter_value == "'AA'" %}. Review the parameter type to ensure that the value evaluates correctly (type: string versus type: unquoted).

AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content