SQL*Plus (MOSC)

MOSC Banner

Merge command fails when combined with Job

in SQL*Plus (MOSC) 3 commentsAnswered ✓

Dear Friends,

When I execute a below merge command it succeed. But the merge command with job fails. Please suggest.

Merge command:

SQL> merge into NCMS20.WEBDATA_MARINE_BUOY@LINK_UDBMARINE_WEB.NCMS.AE dest using (select * from WEBDATA_MARINE_BUOY_STG where to_date(MEASURE_TIME_GST,'YYYY-MM-DD HH24:MI:SS') > sysdate-1) src

2 on (dest.STATION_ID=src.STATION_ID and dest.MEASURE_TIME_GST = to_date(src.MEASURE_TIME_GST,'YYYY-MM-DD HH24:MI:SS'))

3 when not matched then

4 insert(

5 STATION_ID,

MEASURE_TIME_GST,

6 7 WATER_LEVEL,

8 SIGNIFICANT_WAVE_HEIGHT,

9 PEAK_WAVE_PERIOD,

CURRENT_SPEED_BOTTOM,

CURRENT_SPEED_MID,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center