PLS-00103: Encountered the symbol
Hi,on 11g (11.2.0.3)
I meet this error for this part : V.COUNTRY_2CHAR, ' ', ' ', ' ', ' ', ' ', 0,
How should I write it ?
Thank you.
DECLARE
my_task_name VARCHAR2(30);
my_sqltext CLOB;
BEGIN
my_sqltext := '
SELECT B.VAT_ENTITY, A.COUNTRY_VAT_RPTG, B.VAT_DCMNT_ID, B.LINE_NBR, A.VAT_TXN_SOURCE, A.VAT_DST_ACCT_TYPE,
A.VAT_RPTG_CURR_FLG, A.TXN_CURRENCY_CD, A.BASE_CURRENCY, A.CURRENCY_RPTG, A.TAX_BASIS_AMT_TXN, A.TAX_BASIS_AMT_BSE,
A.TAX_BASIS_AMT_RPTG, A.TAX_AMT_GROSS_TXN, A.TAX_AMT_GROSS_BSE, A.TAX_AMT_GROSS_RPTG, A.TAX_TRANS_AMT_TXN, A.TAX_TRANS_AMT_BSE,
I meet this error for this part : V.COUNTRY_2CHAR, ' ', ' ', ' ', ' ', ' ', 0,
How should I write it ?
Thank you.
DECLARE
my_task_name VARCHAR2(30);
my_sqltext CLOB;
BEGIN
my_sqltext := '
SELECT B.VAT_ENTITY, A.COUNTRY_VAT_RPTG, B.VAT_DCMNT_ID, B.LINE_NBR, A.VAT_TXN_SOURCE, A.VAT_DST_ACCT_TYPE,
A.VAT_RPTG_CURR_FLG, A.TXN_CURRENCY_CD, A.BASE_CURRENCY, A.CURRENCY_RPTG, A.TAX_BASIS_AMT_TXN, A.TAX_BASIS_AMT_BSE,
A.TAX_BASIS_AMT_RPTG, A.TAX_AMT_GROSS_TXN, A.TAX_AMT_GROSS_BSE, A.TAX_AMT_GROSS_RPTG, A.TAX_TRANS_AMT_TXN, A.TAX_TRANS_AMT_BSE,
0