Oracle oci stage options

[mrvsr]

I am using Oracle OCI stage input.
Under Input > Sql tab > userdefined ,generated ddl,usedefined ddl tabs got disabled . Please let me know how to enable this option. Which settings have to look into ?

[chulett]

Be more specific with regards to the tabs, exactly what do you mean by they 'got disabled'? You'll never be able to do anything other than look at the DML or DDL on any 'Generated' tab. Any 'user defined' tab will be disabled (as in 'grayed out' or unselectable) if the corresponding Update / Create table / Drop table actions are set to some sort of generated option.

If that's what you are seeing, that's all perfectly normal behaviour.

[sachin1]

i think these tabs are always disabled.

[ray.wurlod]

They are enabled if your Update Action specifies user-defined SQL.

[sachin1]

hello ray please can you please elaborate on it, in my case i have selected OCI stage --> Input tab-->General tab-->(Update existing rows only), but in SQL tab it still shows both of the tabs as disabled.

i have checked for selection like User defined SQL also.

[ray.wurlod]

"Update existing rows only" is NOT "user-defined SQL". Examine the list of possibilities a little more closely.

However, the DDL tabs are only enabled when you check the "create table" check box on the General tab. I misread your original post.

[sachin1]

thank you ray !!