Question

3
Replies
4995
Views
HenryA80 Member since 2015 52 posts
Veteran Careers First
Posted: 2 years ago
Last activity: 2 years 8 months ago
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
Share this page LinkedIn