开发者

Executing PostgreSQL function in informatica

开发者 https://www.devze.com 2023-04-06 02:05 出处:网络
I\'m using informatica desinger and postgres DB and i\'m trying to execute a sql function that i created in sql. I tried to connect them with \"sql transform\" but i get the following error:

I'm using informatica desinger and postgres DB and i'm trying to execute a sql function that i created in sql. I tried to connect them with "sql transform" but i get the following error:

"invalid function agruments", but since I use constants I'm positive that i got them on the right order (i ran the function successfully in postgres)

Help? ple开发者_StackOverflowase...


there could be the error with the comments passed in transformation. You need to make sure function name mentioned is correctly spelled.

0

精彩评论

暂无评论...
验证码 换一张
取 消