Forum Discussion

yes1819's avatar
yes1819
New Contributor III
5 years ago

Oracle SQL insert into values using newly found value

Hi,
I’m trying to insert new values into the existing table in Oracle.
The SP in Oracle is working fine, but Snaplogic throw me an error
Below is Oracle SP. The highlighted Insert into is the one that I’m trying to work in Snaplogic

And below is the error message

Can anyone help?
Thank you

2 Replies

  • Supratim's avatar
    Supratim
    Contributor III
    5 years ago

    @yes1819 Error showing the query is not properly ended, might miss “;” here.
    Also you can try to enable the = and use " " wrapped the query.

  • yes1819's avatar
    yes1819
    New Contributor III
    5 years ago

    I tried end with ; but didn’t like it, and with =, still not working.
    Maybe I need to put one more snap in between P_SNAP_QTR Oracle Execute and this snap that has error?