Calling Stored Procedures in Advanced Queries

Calling Stored Procedures in Advanced Queries

  
Hello!
Is it possible to call an SQL Server stored procedure from within an Advenced Query and access its return value and output variables? If so, how is it done?


Thanks in advance!


João Fialho
Hi João.

You may execute stored procedures like you would do in a command line in SQL Editor.
For example: suppose your stored procedure called "sp_test" returns an integer value.
You create an output struture with an integer variable and just type "sp_test" in the Advance Query Editor.

If you are working with Oracle you may want to try someting like " execute sp_test"

Greetings,

João Caldas