Solved

Build Place Order Enviroment based on branch error

  • 23 October 2023
  • 5 replies
  • 85 views
B
Rank
Userlevel 3
Badge +10

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?

icon

Best answer by bhavesh 24 October 2023, 08:33

View original

5 replies

K
Rank
Userlevel 5
Badge +15

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

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
B
Rank
Userlevel 3
Badge +10

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

B
Rank
Userlevel 3
Badge +10

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?

K
Rank
Userlevel 5
Badge +15

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 “/”.

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
B
Rank
Userlevel 3
Badge +10

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


Terms & ConditionsCookie settings