Skip to main content
Question

Passing table data to procedures.

  • March 12, 2026
  • 0 replies
  • 12 views

Forum|alt.badge.img+3

https://codingsight.com/passing-data-table-as-parameter-to-stored-procedures/

Hi community,

I am trying to implement a feature that will utilize a stored procedure/subroutine that will accept a table as a parameter however i can’t seem to find a way to implement it in the software factory since all subroutine inputs seem to be domains. I found the above topic about this issue but can’t find any followup to the idea. 

Sadly the table valued function workaround is not possible here since im trying to implement the procedure in a trigger which would then pass some values from the inserted rows to the procedure. The temp table strategy would work but is not that much cleaner than just putting in a cursor in the trigger looping over the inserted table.