Unanswered

How to invoke stored procedure with NULL

(1) Share

Report

Posted on by Community Power Pla...

Hi,

I have an issue with passing NULL value to stored procedure. The procedure is a simple INSERT INTO some table. When I run the same procedure from Query editor on database with NULL parameters it works fine. When I do it from Flow, I receive error message that parameter was not supplied:

Same Flow with different values (for example @StartQ = 5) works fine. Is there any method to pass a NULL values to stored procedure (I want to have NULL in database table).

Any idea?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous

Can you please share a screenshot of the flow? Are you passing the null value through an expression or just writing "null"? You might want to try passing through the null expression if not already. Please see the screenshot below:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi,

I'm using an expression. Here is my code:
@{if(equals(9999,triggerBody()['Executestoredprocedure_FinishQ']),null,triggerBody()['Executestoredprocedure_FinishQ'])}
This code generates described error if Executestoredprocedure_FinishQ equals 9999, and works fine in other cases 😞

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous

I would like to see where you are using that expression and I am hoping that you are using the null value from expression editor instead of typing null (as the former would take a null value and the latter would be a string "null")

Hope this Helps!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I have some trouble with uproading screenshot. Please check the link:
https://drive.google.com/open?id=1wM7W_2KP9ka0bS9hP0jlTpjFBe8Kf9Dt

Expession was generated by clicking in expression editor 🙂

Was this reply helpful? Yes No
dixus69 3 on at

Like (0)

Report

Is there really no solution passing null into an sql query using an expression??

The only workaround isn't working in all cases: Use a variable and condition. This is ugly and doesn't work with parallized iterations.

Kind regards,
Holger

Was this reply helpful? Yes No