Using to_dsinterval or INTERVAL with placeholder
- From: MV5492@xxxxxxx (Mike Vanole)
- Date: Tue, 12 Feb 2008 10:17:28 -0600
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
.
- Prev by Date: DBD::Oracle::st fetchrow_hashref warning when fetching multiple records from the table.
- Next by Date: Re: Using to_dsinterval or INTERVAL with placeholder
- Previous by thread: DBD::Oracle::st fetchrow_hashref warning when fetching multiple records from the table.
- Next by thread: Re: Using to_dsinterval or INTERVAL with placeholder
- Index(es):
Relevant Pages
|
|
