Re: Procedure doesn't work
It would be a lot less typing, if you simply did
INSERT INTO ... SELECT ...
with the necessary expressions in the SELECT.
You would probably need to move the procedure argument into @variables.
Also, the single INSERT..SELECT would run a lot faster than the CURSOR.
Subject
Views
Written By
Posted
3472
June 11, 2013 09:21AM
1210
June 11, 2013 12:34PM
1107
June 12, 2013 08:28AM
Re: Procedure doesn't work
1106
June 17, 2013 10:45PM
1070
June 18, 2013 02:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.