# Query does not execute

**URL:** <https://discourse.nodered.org/t/query-does-not-execute/91234>\
**Category:** General\
**Created:** [24 September 2024 16:04 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234 "2024-09-24T16:04:23Z")\
**Posts on this page:** 10\
**Page:** 1

<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:** [24 September 2024 16:04 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/1 "2024-09-24T16:04:23Z")

</div>

Good day.  
I have a situation with a query that seems to execute correctly ( I say seems because I get no errors) but in the server nothing is updated.  
My payload looks like this:

```auto
{
  StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}

```

and my flow is like this:

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

The "Upgrade SHRDMGR" node receives the payload fine (as per the debug node) but the server  
produced no updates.

The SQL in Upgrade SHRDMGR is as follows:

```auto
begin 
 baninst.learneroutcome.p_update(
        :StudentPIDM,
        :DegreeSequence,
        :OutcomeStatus,
        TO_DATE('10000101', 'YYYYMMDD'),
        TO_DATE(:GraduationDate,'MM/DD/YYYY'),
        '',
        :term,
        '',
        '',
        :GraduationStatus,
        '',
        TO_DATE('10000101', 'YYYYMMDD'),
        '',
        '',
        '',
        '',
        '',
        '',
        '',
        USER,
        'GradAutomation',
        NULL,
        NULL
    );
end;

```

Any ideas to tackle this problem?

p.s. I'm using oracle-exec if that helps.

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [24 September 2024 16:38 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/2 "2024-09-24T16:38:15Z")

</div>

In your flow there is no debug attached to the `upgrade` node.

---

<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:** [24 September 2024 16:50 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/3 "2024-09-24T16:50:51Z")

</div>

Sorry. I copied the altered version.

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

Nevertheless, the result in updateDbg is :

{

```auto
  StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}

```

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [24 September 2024 17:58 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/4 "2024-09-24T17:58:39Z")

</div>

1. What is the full name of the 'oracle-exec' node? Searching - using the `flows` tab with the keyword 'oracle' doesn't show any node with 'exec' in it.

2. What is the output of the `termDog` debug node? and can you set it to display the complete msg object. And copy and paste the output to a reply.

3. Also set the `updateDbg` node to display the complete msg object also paste that to your reply.

---

<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:** [24 September 2024 18:38 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/5 "2024-09-24T18:38:47Z")

</div>

@zenofmud,

Thanks for your reply.  
1.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/d/ddad7c7809cdb99f7a1ca80edcb2a112449b48a8.png)

1. termDbg node:

```auto
{
StudentPIDM: 123456
  DegreeSequence: 1
  OutcomeStatus: "GR"
  GraduationStatus: "WG"
  GraduationDate: "9/30/2024"
  term: "202310"
}

```

1. updateDbg node: Is the same as termDbg

Because _updateDbg_ has the correct information and _updateError_ has not errors, at first glace I thought it was OK, until I checked the actual server and had not updated the info.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [24 September 2024 22:30 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/6 "2024-09-24T22:30:25Z")

</div>

What would you expect the output of the `update SHRDMGR` to be?

Also it doesn’t look like you changed the debug node to display the complete msg object.

---

<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:** [25 September 2024 16:27 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/7 "2024-09-25T16:27:01Z")

</div>

@zenofmud,

I'm not sure I understand your question. (sorry, I'm new to NR).  
What do you mean by "changed the debug node to display the complete msg".

Is there a way to produce more output from the debug node?  
If that's the case, could you tell me how to enable it?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [25 September 2024 16:40 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/8 "2024-09-25T16:40:57Z")

</div>

Set it in the Output field dropdown

---

<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:** [25 September 2024 17:59 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/9 "2024-09-25T17:59:17Z")

</div>

Thanks Colin!!

@zenofmud,  
I got it to work. Appreciate your 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 December 2024 17:59 UTC](https://discourse.nodered.org/t/query-does-not-execute/91234/10 "2024-12-24T17:59:44Z")

</div>

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