• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

vvOut_execSqlToJson

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

  • vvOut_execSqlToJson

    Hi,
    I am trying to use vvOut_execSqlToJson(vvOut:lStmt) to execute a prepared SQL/JSON statement. The SQl that is prepared just inserts data into a file. It doesn't return any response to the browser.

    If I run the same tailored SQL outside, i am able to insert the records into the target file, where as when i pass the SQL Statement(lStmt) to vvOUT_execSQLToJson as above, records are not being inserted.
    Could you please let me know if I am using this procedure correct? or is there any other alternative proc that can be called?
    Regards,
    Pavan

  • #2
    execSQLtoJSON is not designed for that kind of use.

    You should probably be using execute immediate :stmt to accommodate a file insert like that.

    Comment


    • #3
      That helps. Thanks Rob

      Comment

      Working...
      X