stored procedure truncating
This is likely a really simple oversight on my part. I have two stored procedures that look like this:
UPDATE joblisttable
INNER JOIN joblistfromdevice
ON joblisttable.jobnumber=joblistfromdevice.jobnumber
SET joblisttable.jobstart= joblistfromdevice.jobstart;
DELETE joblistfromdevice
FROM joblistfromdevice
INNER JOIN joblisttable ON joblisttable.jobnumber=joblistfromdevice.jobnumber;
Whenever I put them into the same SP, everything after the first ";" is removed on saving. Any ideas?
Thanks in advance!
Subject
Views
Written By
Posted
stored procedure truncating
824
April 20, 2018 10:44AM
608
April 20, 2018 11:46AM
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.