Front page | perl.dbi.users |
Postings from February 2008
This may be less a DBI question and more Oracle - probably both...
Using DBD::Oracle
Given this table:
TABLE batch_application_sla
Name Null? Type
----------------------------------------- --------
----------------------------
ASSOCIATION VARCHAR2(100)
SLA INTERVAL DAY(2) TO
SECOND(6)
DISPLAY CHAR(1)
SUMMARY_DISPLAY CHAR(1)
LOAD_STATUS VARCHAR2(20)
PROCESS_DATE DATE
DESCRIPTION VARCHAR2(300)
SLA_DISP CHAR(1)
SLA_ADD_DAYS NUMBER
I can insert a row as follows:
insert into batch_application_sla
values('YYY',interval '23:32' HOUR to
MINUTE,'y','y','COMPLETE',to_date('2008/01/01',
'YYYY/MM/DD'),'TEST','y',0)
How can I use placeholders? I'm getting various errors with the
INTERVAL. This is one version:
INSERT into batch_application_sla
values(?,to_dsinterval(?,'HH:MI' HOUR to MINUTE),?,?,?,to_date(?,
'YYYY/MM/DD'),?,?,?)
The source data I'm loading is in "HH:MI" format, but I can transform it
into anything.
I've also tried:
INSERT into batch_application_sla
values(?,INTERVAL ? HOUR to MINUTE,?,?,?,to_date(?, 'YYYY/MM/DD'),?,?,?)
Many thanks,
Mike
Thread Next