Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Call DB Procedure not returning the result for Postgres function

  1. #1

    Default Call DB Procedure not returning the result for Postgres function

    Hi All,

    I'm using Call DB Procedure to call Postgres function which returns String.

    The Call DB procedure calling the function and exceuting all statement but not returning the result.

    I can see result always empty.I checked the function call manually(offline kettle) and it returns result as expected .


    Please help me in this regards.

  2. #2
    Join Date
    Feb 2009
    Posts
    321

    Default

    a sql script (I think) step does not return any value. Put the value in a tmp table and then you will use in a query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.