Question

3
Replies
5413
Views
Close popover
Henry Allen (HenryA80)
Veteran Careers First

Veteran Careers First
US
HenryA80 Member since 2015 57 posts
Veteran Careers First
Posted: February 15, 2018
Last activity: March 5, 2018
Closed
Solved

Stored Procedure & Connect-SQL

Trying to get clarification on SQL statement to call stored procedure for Oracle. There seems to be a few different ways to do it. Here is what I came up with so far.

\{Call My_Stor_Proc ({.My_parameter1 in}, {.My_Parameter2 in}, {.My_Parameter3 in}, {.My_Parameter4 out } {resultset}) \}

  • Does what I have look correct.
  • Which tab on the Connect-SQL rule (Open or Browse)
  • If 'out' is the result property, then what is the purpose of 'resultset'
  • What is the purpose of {SQLPage:mySQLPage}
Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.