# Unrecognized bind variable passed to the bind call

**URL:** <https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339>\
**Category:** General\
**Tags:** node-red-contrib-oracledb-2\
**Created:** [22 August 2024 16:14 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339 "2024-08-22T16:14:13Z")\
**Posts on this page:** 7\
**Page:** 2

<div class="post-metadata">

**Author:** ![ralvez](https://avatars.discourse-cdn.com/v4/letter/r/a6a055/32.png) [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Post date:** [26 August 2024 14:57 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/21 "2024-08-26T14:57:08Z")

</div>

Hi Steve,

I modified the flow. It looks like this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/b/cb8e1c0ecd1a53a6ebd9d039a44db15e723c704e.png)

You will notice that there are 2 items in Distinction that is connected to the template (where the code is) and then to the DB.

The error is the yet the same. That's what makes me think of corruption.  
To be honest I'm kinda lost now 🙂

---

<div class="post-metadata">

**Author:** ![ralvez](https://avatars.discourse-cdn.com/v4/letter/r/a6a055/32.png) [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Post date:** [26 August 2024 15:00 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/22 "2024-08-26T15:00:30Z")

</div>

BTW. If you think that being able to see the whole flow may be helpful I can post it.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [26 August 2024 15:10 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/23 "2024-08-26T15:10:01Z")

</div>

> [@ralvez](#):
>
> If you think that being able to see the whole flow may be helpful I can post it.

No, you have too many bespoke nodes that talk to "things" I dont have nor do i have access to your "things".

What i am confused about here is: you have implemented the stuff I said to do (in a function) BUT you have a template node going into the SQL node!!!

Show me the output of "Debug 156"

---

<div class="post-metadata">

**Author:** ![ralvez](https://avatars.discourse-cdn.com/v4/letter/r/a6a055/32.png) [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Post date:** [26 August 2024 16:31 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/24 "2024-08-26T16:31:40Z")

</div>

The outpu of debug 156 is:

`{"Student PIDM":740840,"Student ID":200516153,"Degree Sequence":1,"Institutional Honors":"D","Transcript Indicator":"Y","Commencement Report":"Y"}`

Which BTW is the same as the output of the Distinction node which is connected to the template.

Now I have a question.  
I understood that the idea was to implement your code suggestion in the template but your comments make me think that, if fact, that may not have been your intention.  
Did I misunderstand something?

---

<div class="post-metadata">

**Author:** ![ralvez](https://avatars.discourse-cdn.com/v4/letter/r/a6a055/32.png) [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Post date:** [26 August 2024 16:48 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/25 "2024-08-26T16:48:53Z")

</div>

I made some changes to the code based on your comment where you mentioned that you where thinking of a function. ( Well, I think that's what you meant 🙂 )  
So it now looks like this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/d/4d1fa590f5a9550ebd74b1a0802173216aa0aae4.png)

I get a "better" result as it seems to like to execute the query without the Student PIDM error.  
I have to test further but I think we made progress in the right direction. Thanks!!

---

<div class="post-metadata">

**Author:** ![ralvez](https://avatars.discourse-cdn.com/v4/letter/r/a6a055/32.png) [@ralvez](https://discourse.nodered.org/u/ralvez)\
**Post date:** [26 August 2024 16:58 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/26 "2024-08-26T16:58:09Z")

</div>

@Steve-Mcl ,

After a few tests I think we are good. I did not get in your earlier comments that we were replacing the template with a function.  
Using a function and placing the code to be executed in the oracle-db (SHDGIH INSERT) does the trick.  
Thanks for all the help.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [24 November 2024 16:58 UTC](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339/27 "2024-11-24T16:58:31Z")

</div>

Closed on 24 November 2024 16:58 UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

[Previous page](https://discourse.nodered.org/t/unrecognized-bind-variable-passed-to-the-bind-call/90339.md?page=1)
