The whole script looks like this.
SET SERVEROUTPUT ON
-----------------------------------------------------------------------------
-------------------- TABLE DEFINITIONS --------------------------------------
-----------------------------------------------------------------------------
-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
table_name_ VARCHAR2(30) := 'C_CONTRACT_STATUS_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'STATUS', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'DESCRIPTION', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Set_Table_Column(columns_, 'ROWSTATE', 'VARCHAR2(20)', 'N');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
/
DECLARE
table_name_ VARCHAR2(30) := 'SALES_CONTRACT_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'C_WEEKLY_CONTRACT_VALUE', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_CUSTOMER_ADDRESS', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_PROCESS_PLANT', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_ON_SITE_SERVICE', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_CONTRACT_STATUS', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_INSTALL_DATE', 'DATE', 'Y');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
/
DECLARE
table_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'GUID', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Set_Table_Column(columns_, 'CUSTOMER_ID', 'VARCHAR2(20)', 'N');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'CONTACT1', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT2', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT3', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT4', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT5', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT6', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT7', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT8', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT9', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT10', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT11', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT12', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT13', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT14', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT15', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO_TYPE', 'VARCHAR2(20)', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, '&IFSAPP_DATA', NULL, TRUE);
END;
/
-- [END IFS COMPLETE BLOCK]
-----------------------------------------------------------------------------
-------------------- INDEX DEFINITIONS --------------------------------------
-----------------------------------------------------------------------------
-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
index_name_ VARCHAR2(30) := 'CONTRACT_STATUS_PK';
table_name_ VARCHAR2(30) := 'CONTRACT_STATUS_TAB';
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'STATUS');
Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'P', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
-- [END IFS COMPLETE BLOCK]
/
-- [IFS COMPLETE BLOCK DECLAREEND]
DECLARE
index_name_ VARCHAR2(30) := 'CONTRACT_STATUS_RK';
table_name_ VARCHAR2(30) := 'CONTRACT_STATUS_TAB';
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'ROWKEY');
Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'U', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
-- [END IFS COMPLETE BLOCK]
/
DECLARE
index_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_PK';
table_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_TAB';
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'GUID');
Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'P', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
/
DECLARE
index_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_RK';
table_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_TAB';
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'ROWKEY');
Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'U', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
/
DECLARE
index_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_IDX1';
table_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_TAB';
columns_ Database_SYS.ColumnTabType;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'CUSTOMER_ID');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO_TYPE');
Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'U', '&IFSAPP_INDEX', NULL, TRUE, TRUE);
END;
/
SET SERVEROUTPUT OFF
And then the error log shows
!!!Error deploying file conmgt/080723_BPATEL_SP004.cdb at 23-OCT-23 09:53:38
!!!Error occurred while executing Plsql Block
DECLARE
table_name_ VARCHAR2(30) := 'C_CONTRACT_STATUS_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'STATUS', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'DESCRIPTION', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Set_Table_Column(columns_, 'ROWSTATE', 'VARCHAR2(20)', 'N');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, 'IFSAPP_DATA', NULL, TRUE);
END;
/
DECLARE
table_name_ VARCHAR2(30) := 'SALES_CONTRACT_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'C_WEEKLY_CONTRACT_VALUE', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_CUSTOMER_ADDRESS', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_PROCESS_PLANT', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_ON_SITE_SERVICE', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_CONTRACT_STATUS', 'VARCHAR2(200)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'C_INSTALL_DATE', 'DATE', 'Y');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, 'IFSAPP_DATA', NULL, TRUE);
END;
/
DECLARE
table_name_ VARCHAR2(30) := 'C_CUSTOMER_CONTRACT_INFO_TAB';
columns_ Database_SYS.ColumnTabType;
column_ Database_SYS.ColRec;
BEGIN
Database_SYS.Reset_Column_Table(columns_);
Database_SYS.Set_Table_Column(columns_, 'GUID', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Set_Table_Column(columns_, 'CUSTOMER_ID', 'VARCHAR2(20)', 'N');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO', 'VARCHAR2(50)', 'N');
Database_SYS.Set_Table_Column(columns_, 'CONTACT1', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT2', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT3', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT4', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT5', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT6', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT7', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT8', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT9', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT10', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT11', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT12', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT13', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT14', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTACT15', 'VARCHAR2(50)', 'Y');
Database_SYS.Set_Table_Column(columns_, 'CONTRACT_NO_TYPE', 'VARCHAR2(20)', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', 'sys_guid()');
Database_SYS.Create_Or_Replace_Table(table_name_, columns_, 'IFSAPP_DATA', NULL, TRUE);
END;
/
ORA-06550: line 14, column 1:
PLS-00103: Encountered the symbol "/"