PL/SQL (MOSC)

MOSC Banner

Not able to execute trigger through shell script

edited Apr 6, 2022 11:58PM in PL/SQL (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center