How to retrieve oracle table structure at run time

[Anonymous]

Hi,

Can anybody let us know how can we reterive Oracle table structure at run time and use that same structure for tFileinputDelimited component as a schema ?

Regards,

Vivek 

[fdenis]

you can use sys.All_Objects views you may need more rights to access sys tables ask to your oracle admin

[Anonymous]

Thats fine,how can we use that table structure as tFileInputDelimited schema ?

[fdenis]

you can use dynamic type who include the structure.
or just use field name (delimited file have not type)