|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Newbie quickie
hi guys
I have done afiar amount of Selects on Oracle databases. I am now trying to insert a row. The code below keeps returning this error message: Code:
ERROR at line 68: ORA-00917: missing comma Here's the SQL: Code:
insert into xc_activity
(ACT_C_UPDATEIND,
ACT_C_ACTVTYID,
ACT_V_DESC,
ACT_D_DUEDATE,
ACT_N_DURATION,
ACT_C_DURATIONSLOT,
ACT_N_PRIORITY,
ACT_C_TYPE,
ACT_C_STATUS,
ACT_C_METHOD,
ACT_C_DIRECTION,
ACT_C_USERID,
ACT_C_ASSIGNBY,
ACT_C_ASSIGNTO,
ACT_C_ESTABID,
ACT_C_SELSEQID,
ACT_D_COMPLETEDT,
ACT_D_LUPDATE,
ACT_C_DELFLAG,
ACT_C_NEWOLD,
ACT_C_ASSIGNSTAT,
ACT_N_DBID,
ACT_C_NOTEFLAG,
ACT_V_TYPEDESC,
ACT_V_METHODESC,
ACT_C_SELCYCLE,
ACT_C_ACTIONBY,
ACT_C_ESTABNUM,
ACT_V_ESTABSHNAME,
ACT_C_SELREASONCD,
ACT_V_SELREASONDESC,
ACT_V_DUEDATE,
ACT_D_CREATEDT)
values
('NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN',
'xclBBFAAAAOB',
'Dave Reynolds,Government Office fo (CD01357557),01159 712420',
to_date('06/02/2003 12:58','DD/MM/YY HH:MI') ,
'0',
'MIN',
'1',
'12',
'C',
'1',
'O',
'TBCLEAD1',
'LEADT1',
'LEADT1',
'LEG000257544',
'xclBBFAAAAAG',
to_date('06/02/2003 12:58','DD/MM/YY HH:MI') ,
to_date('06/02/2003','DD/MM/YY') ,
'N',
'',
'0',
'115',
'N',
'Cancel',
'Call',
'1',
'EMP',
'CD01357557',
'Dave Reynolds,Government Office fo',
'15',
'No Interest',
'20030206',
to_date('06/02/2003 12:57','DD/MM/YY HH:MI') ;
Any Ideas ? |
|
#2
|
|||
|
|||
|
W00t missing the last bracket from the value section
DOH |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Newbie quickie |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|