[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