Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Variable procedure name in "Call DB Procedure"

  1. #1
    Join Date
    Feb 2007
    Posts
    230

    Default Variable procedure name in "Call DB Procedure"

    Hi,

    Is it possible to use a variable procedure name (proc-name) in "Call DB Procedure" step?

    I have to call some MySQL stored procedures whose names are "dynamic".

    I didn't find a solution for doing it in sql script :-(

    regards, dejan

  2. #2
    pstoellberger Guest

    Default

    why not using sql script?

    call ?(?); and enable variable substitution
    with parameters 1: sp_name 2: parameter

  3. #3
    Join Date
    Feb 2007
    Posts
    230

    Default

    I could do that. But if I have a function and want to return a value then it is not possible right?

    regards, dejan

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.