You are viewing limited content. For full access, please sign in.

Question

Question

ORA-01036 illegal variable name/number

asked on March 18, 2024

Beginner in LF workflow
facing ORA-01036 illegal variable name/number
Same configuration in other workflow is running fine but facing issue in the new workflow.
What could be the issue?
Any help/ guidance is appreciated.

0 0

Answer

SELECTED ANSWER
replied on March 18, 2024

Thanks for the clue the issue was because of name mismatch of the variable
the difference was there was 1 extra space and that was causing the variable name mismatch
it happened because of copy paste variable name was same but 1 additional space came as a result of copy paste.
Thanks a lot for guidance.... It helped me to looks in this direction
 

0 0

Replies

replied on March 18, 2024

This appears to be an Oracle error. Could you possibly be passing a variable with an undefined/null value as part of your query? Here's a post that might help narrow it down.

oracle - ORA-01036: illegal variable name/number when running query through C# - Stack Overflow

1 0
SELECTED ANSWER
replied on March 18, 2024

Thanks for the clue the issue was because of name mismatch of the variable
the difference was there was 1 extra space and that was causing the variable name mismatch
it happened because of copy paste variable name was same but 1 additional space came as a result of copy paste.
Thanks a lot for guidance.... It helped me to looks in this direction
 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.