Not able to execute trigger through shell script
Hi All,
We have requirement underwhich we want to alter length of column cust_name from table GETS_CSI_IB_ITEM_INSTANCE_STG, as per suggestion from internal team, we will following following steps.
1. alter table and add column as cust_name#1
2. Using trigger, assigning old column value to new column which will synchronuize values into new column
3. To execute the trigger, we have to use the shell script.
But using the shell script we are not able to execute the trigger. Below is the shell script code :
---------Start of shell script-----------------------
# User Input for the driving the shell file