[Asterisk-Users] Yada table in oracle

Han van Hulst han.vanhulst at gmail.com
Thu Sep 29 12:13:52 MST 2005


I just compiled yada and cdr_yada
Everything is working only I get an error when asterisk tries to insert a
record into the database
 
Sep 29 21:05:24 ERROR[5091]: cdr_yada.c:445 cdr_yada_log: Failed to insert
row: ORA-01861: literal does not match format string
 
I made to follow table in Oracle 
 
SQL> desc cdr_yada
 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 ID                                                 NUMBER(38)
 CALLDATE                                           DATE
 ACCOUNTCODE                                        VARCHAR2(20)
 SRC                                                VARCHAR2(80)
 DST                                                VARCHAR2(80)
 DCONTEXT                                           VARCHAR2(80)
 CLID                                               VARCHAR2(80)
 CHANNEL                                            VARCHAR2(80)
 DSTCHANNEL                                         VARCHAR2(80)
 LASTAPP                                            VARCHAR2(80)
 LASTDATA                                           VARCHAR2(80)
 DURATION                                           NUMBER(38)
 BILLSEC                                            NUMBER(38)
 DISPOSITION                                        VARCHAR2(45)
 AMAFLAGS                                           NUMBER(38)
 UNIQUEID                                           VARCHAR2(32)
 USERFIELD                                          VARCHAR2(255)

 
Who can help me with this problem 
 
Thanks Han
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050929/55ff474c/attachment.htm


More information about the asterisk-users mailing list