Oracle SQL insert into values using newly found value

Question

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

supratim · Answer

yes1819:

The highlighted Insert into is the one that I’m trying to work in Snaplogic

@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 · Answer

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?

Forum Discussion

Oracle SQL insert into values using newly found value

Recent Discussions

Automating Untracked assets to GIT

Pagination and nextCursor in header

How to get filename from file reader

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?