Skip to Content (Press Enter)
UserImage.jpg
Omran Bhatti
882Views
4Comments
Trying to CALL a SQL FUNCTION 
Question

I am trying to call a SQL Function from a Server Action 

I am using the following :- 

             

SyntaxEditor Code Snippet

/* %LogicalDatabase%=GetLogicalDatabase({ScriptHistory}) */
SELECT @MemberNo = [MDU].[SALES_APP_XML](NULL,@MemberNo)


Keeps throwing an Error 

What am I doing wrong ?





0
0
19 Apr 2018
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP

@Omran

What's the error?

0
0
19 Apr 2018
Copy Link
2020-02-28 09-46-54
Eduardo Jauch

Hi Omran

By Function are you talking about Stored Procedure?
If so, take a look here: https://www.outsystems.com/forums/discussion/14867/how-to-execute-stored-procedures/

In Oracle it is better to use the Oracle Connector (from Forge).

Cheers.

0
0
19 Apr 2018
Copy Link
2019-04-17 09-04-09
Sérgio Pereira

Omran Bhatti wrote:

I am trying to call a SQL Function from a Server Action 

I am using the following :- 

             

SyntaxEditor Code Snippet

/* %LogicalDatabase%=GetLogicalDatabase({ScriptHistory}) */
SELECT @MemberNo = [MDU].[SALES_APP_XML](NULL,@MemberNo)


Keeps throwing an Error 

What am I doing wrong ?





Hi Omran,


Did you manage to resolve the error being thrown?


Thanks


0
0
18 Sep 2019
Copy Link
UserImage.jpg
Lawrence Arielle .

when calling SQL function from outsystems, always specify the database name.


Format:

[DatabaseName].[Schema].FunctionName

0
0
06 Mar 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.