Re: Creating a procedure to insert from one table to another

Posted by ErmanArslansOracleBlog on Jan 12, 2018; 10:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Creating-a-procedure-to-insert-from-one-table-to-another-tp4888p4893.html

Okay. I saw your problem..
You are missing the "into" clause in your sql.

Ex:

insert into TABLE ....blabla

Also, you may use MERGE statement rather than this insert.. It may be more logical for your case..