Skip to Content (Press Enter)
UserImage.jpg
João Fialho
3Views
1Comments
Calling Stored Procedures in Advanced Queries
Question
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
0
0
18 Dec 2008
Copy Link
2017-11-01 18-37-40
João Caldas
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
0
0
19 Dec 2008
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.