Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 sql apex dynamic action

Author  Topic 

angela_g
Starting Member

17 Posts

Posted - 2013-09-18 : 12:56:44
Hi I'm trying to use this SQL as a dynamic action in APEX but i am getting the following error message. Can someone tell me where I am going wrong please?

UPDATE RE_EZPAY_AT_AGENCY_DAILY
SET RE_EZPAY_AT_AGENCY_DAILY.STATUS = H
WHERE RE_EZPAY_AT_AGENCY_DAILY.DEBT >250
AND RE_EZPAY_AT_AGENCY_DAILY.STATUS = O;

•ORA-06550: line 5, column 1: PLS-00428: an INTO clause is expected in this SELECT statement
   

- Advertisement -