Announcement

Collapse
No announcement yet.

Stored Procedures: run() return type

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedures: run() return type

    Per the schema compiler, run() can return long, Long, VoltTable or VoltTable[]

    I have a stored proc returning long, and cannot find in the documentation how to access the value.

    Results.table is an empty array in this case. Anybody know how I get my long value? I am using voltjs node client.

    Thanks

    jeff

  • #2
    I think I may have had an error in my stored proc, because I see the result in result.tables[0][0] now

    Comment


    • #3
      Procedures always return an array of tables. Returning a long or scalar VoltTable from your procedure is just a convenience. Ultimately that long will be put in a one-column, one-row VoltTable and put into an array of length 1.

      So what you're seeing is expected.

      Comment


      • #4
        Procedures always return an array of tables. Returning a long or scalar VoltTable from your procedure is just a convenience. Ultimately that long will be put in a one-column, one-row VoltTable and put into an array of length 1.

        So what you're seeing is expected.

        Comment

        Working...
        X