Link to home
Start Free TrialLog in
Avatar of Info_user100
Info_user100

asked on

missing expresion

what is wrong with this statement
the fields of the table are:
pin_no varchar2(12)
amount number(10,3)
payment_type varchar2(20)
payment_date date
index_no varchar2(12)
c_card_no varchar2(20)
check_no number(20)
accou_no number(15)
exp_date date
bank varchar2(20)
operator varchar2(20)
code varchar2(20)

------------------------------------------------------------
insert into customer_credit values('WEB00001', 10,'PrePaid CC', to_date('10/15/1999 09:03:00','mm/dd/yyyy hh24:mi:ss'),'','4111111111111111',,,to_date('01/10/1999','mm/dd/yyyy'),'','self','Cyber')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression

/michaelmarom-23/mck-cgi/directpaycredit.asp, line 73
ASKER CERTIFIED SOLUTION
Avatar of meowsh
meowsh
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Info_user100
Info_user100

ASKER

Meowsh you were right the absence of NULL was throwing me off.      

Thanks
Max.