Six Stars

How to retrieve oracle table structure at run time

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 

3 REPLIES
Ten Stars

Re: How to retrieve oracle table structure at run time

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

Francois Denis

Don't forget to tag when it's "solved"!

Six Stars

Re: How to retrieve oracle table structure at run time

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

Ten Stars

Re: How to retrieve oracle table structure at run time

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

Francois Denis

Don't forget to tag when it's "solved"!