Datadeploy Question

System

Hi.
I want to deploy a Teamsite DCR to the Database using Datadeploy and iwdd.ipl.In the datadeploy config file In one of the columns(CONTENT_ID) i want to use a value from a sequence number generated by a oracle sequence. Like:
<column name="CONTENT_ID" data-type="VARCHAR(10)" value="**SQLVALUE**" allows-null="no" />

I want to 1) Execute the "Select contentidseq.nextval from dual ;"
2) And use this value in the "column" tag above.
is there a way to do it?
Thanks

Migrateduser

If I understand the question correctly - I assuming you want to know how to call that unique sequence?
I'm utilizing something very similiar to what your doing with Oracle8i - what we've done in on the DCT we have a hidden field that is a read only field which makes an inline call to a Perl script (Interwoven download code from site - iw_solution_inlinecallout.ipl):
http://devnet.interwoven.com/site.fcgi/techlib/049553
NOTE: In this perl script you have to add three environment vars for
BEGIN {
$ENV {ORACLE_HOME} = 'D:\oracle\ora81';
$ENV {Path} = 'D:\oracle\ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;d:\iw-home\Interwoven\teamsite\iw-perl\bin;D:\iw-home\Interwoven\OpenDeploy\OpenDeployNG\bin';
$ENV {SystemRoot} = 'C:\WINNT';
}

If you need more info - let me know

Thanks