Dear All,
I have followed how to execute a stored procedure, but when I try in service studio by calling my stored procedure and I try to run, an error message appears like this
/* %LogicalDatabase%=GetLogicalDatabase({prj}) */ EXEC dbo.STORED_PROSEDURE_NAME
Thanks,
Kane
Hi Kane,
you have to use brackets: EXEC [dbo].[STORED_PROSEDURE_NAME]
check this topic for more details:
https://www.outsystems.com/forums/discussion/14867/how-to-execute-stored-procedures/
Regards
Hi Jose,
I've done that way to the end, and I've added brackets.
and I've changed
/* %LogicalDatabase%=GetLogicalDatabase({prj}) */
to
/* %LogicalDatabase%=GetLogicalDatabase({TABLE_NAME}) */
but still get same error
You can only execute store procedures if you are working on an on-premises infrastructure where you can adjust security settings to do so.
Take a look at this step-by-step guide, with screenshots, on how to execute store procedures using OutSystems.
Kind Regards,João
Hi Joao,
Yap, I've done all the steps, including the security step, but service studio still can't find my stored procedure
From your message, the stored procedure cannot be found, so I'd check for typos and would make sure that the OSRUNTIME is given proper access to execute stored procedures (step #2 on the guide).
My suggestion would be to retrace back each single step to make sure you haven't miss anything.
On top of that, you can also check the How To Execute Store Procedures forge component, based on the same article I shared.