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.
Question
Question
ORA-01036 illegal variable name/number
Answer
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
Replies
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
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