Hi everyone.
I've been staring at this piece of code for a couple of hours now, and I can't see a reason as to why this would fail. I've based the code on something I've used on other platforms, but I'm still fairly new to Oracle...
If I remove the "INTO JT_EVTLOG" line, the Select code works a charm, I just can't get the output into the other table, with the error, "Missing Keyword"
As far as I can tell, the JT_EVTLOG table is constructed appropriately to recieve the intended data so I'm stumped as to where to go next, other than continuing my searching, can anyone point me in the next direction?
For completion, here's the table create script.
Thanks in advance,
Jon
I've been staring at this piece of code for a couple of hours now, and I can't see a reason as to why this would fail. I've based the code on something I've used on other platforms, but I'm still fairly new to Oracle...
Code:
SELECT LOG_KEY, LOG_USER_CDE, LOG_SHORT_DESC, LOG_CRT_DATE
INTO JT_EVTLOG
FROM EVENTLOG
WHERE LOG_CRT_DATE LIKE TO_DATE ('18-FEB-2011 00:00:00', 'DD-MM-YYYY HH24:MI:SS')
If I remove the "INTO JT_EVTLOG" line, the Select code works a charm, I just can't get the output into the other table, with the error, "Missing Keyword"
As far as I can tell, the JT_EVTLOG table is constructed appropriately to recieve the intended data so I'm stumped as to where to go next, other than continuing my searching, can anyone point me in the next direction?
For completion, here's the table create script.
Code:
CREATE TABLE "INSTEST"."JT_EVTLOG"
(
"LOG_KEY" NUMBER(10,0) NOT NULL ENABLE,
"LOG_USER_CDE" NUMBER(10,0),
"LOG_SHORT_DESC" VARCHAR2(50 BYTE),
"LOG_CRT_DATE" DATE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "USERS" ;
Thanks in advance,
Jon