Skip to main content

I am getting below error due to script in the .cdb file

ORA-06550: line 14, column 1:
PLS-00103: Encountered the symbol "/" 

!!!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_, '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;
/

I do not get this error when deploying this cdb file through the development studio. Does anyone know what causes this error?

Maybe there is one more script with BEGIN .. END block without “/”?


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 "/" 


All begin..end block ends with “/” in the cdb file. It runs perfectly fine using development studio. But does not working during environment creation. Anything else you can think of?


Installer informs that error is comming from Your cdb file. But let suppose there is another cdb file with block BEGIN … END; without “\” launched before Your cdb file. Then we have:

BEGIN … END;

BEGIN… END;

/

With this You have two blocks in buffor. Next “/” trying upload two blocks at the same time and that might be a problem with missing “/”.


I only have one cdb file in the component.

However, when I removed below comments

-- [END IFS COMPLETE BLOCK] 

It worked fine. Not sure why the comment made a difference.


Reply