Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: calling stored procedure issue

  1. #1
    Join Date
    Aug 2008
    Posts
    18

    Default calling stored procedure issue

    Hello

    i'm calling a stored procedure to carry out checks with the key field from the input stream and database and get the database field if they match.

    I keep on getting this error so i was wondering how i can make the changes in the connection ?

    User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.

    regards

  2. #2
    Join Date
    Aug 2008
    Posts
    18

    Default

    I understand that there is a bug created in relation to this.

    http://jira.pentaho.com/browse/PDI-2244

    Any advise on workarounds in the meantime will be highly appreciated.

    regards

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.