Dear Experts,
I am trying to get the source code from all_views and executing it dynamically. I referred all_view table and the TEXT column which has LONG type. One particular view query seems to be longer. So some position of the query is coming on the next line which is leading to the dis-continuity of the lines and creating problem. Please continue reading
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
"CORE 12.2.0.1.0 Production"
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production
select text from all_views
where view_name = 'STOCKS'
AND OWNER = 'GMMANAGER';
Section:1
"select "ID","CREATED_BY","CREATED_DATE","NAME","PPV_ADDR_UPDATABLE_FLAG","GRANT_ADDR_UPDATABLE_FLAG","WEB_AUTHORIZATION_FLAG","SYSTEM_TYPE","FILE_TICKER","TICKER_SYMBOL","CORP_NAME_VOCAB_NUM","TRADED_BY_CORP_ID","MELLON_PLUS_ACCT_NUMBER","MINIMUM_COMMISSION","COMMISSION_PER_SHARE","TRANSFER_TOTAL_PLANS","TRANSFER_FILTER_
FLAG","TAX_IDENTIFIER","GRANT_TRADES_FILE_SENT","GRANT_EMP_FILE_RECEIVED","PPV_TRADES_FILE_SENT","PPV_EMP_FILE_RECEIVED","GRANT_PERSSUM_FILE_RECEIVED","PPV_PURCHASES_FILE_RECEIVED","ADDRESS_LINE_1","ADDRESS_LINE_2","ADDRESS_LINE_3","CITY","STATE",
"ZIP","ZIP4","INCOMING_SEQUENCE","INCOMING_SEQUENCE_DATE","OUTGOING_SEQUENCE","OUTGOING_SEQUENCE_DATE","ALERT_NAME","BLACK_OUT_NPA","BLACK_OUT_COP","BLACK_OUT_LINE_NUMBER","BLACK_OUT_START_DATE","BLACK_OUT_END_DATE","BLACK_OUT_AUTHORIZATION_NAME","UP
DATED_BY","UPDATED_DATE","NEW_EMPLOYEE_BLOCK_FLAG","SERVICE","LOG_DIR","NOTES","STARTUP_HOST_NAME","TARGET_HOST_NAME","SAVE_BLOCKING_CODE_FLAG","GTC_TO_DAY_FLAG","OPTIONS_ONLY_FLAG","OPTIONS_AND_PPV_FLAG","PPV_ONLY_FLAG","VESTING_SCHEDULE","SEND_UP
G","NPC_EXTRACT","STOCK_ADMIN_EMAIL","CORPFEE_ID","PPV_SCHEDULE_ID","GRANT_SCHEDULE_ID","QSALE_SCHEDULE_ID","LOGO_NAME","EMPS_EXTRACT","COUNTRY","CUSIP","USE_SECONDARY_ADDR_FLAG","PRIVATE_FLAG","SA_ALLOWED_FLAG","CASH_EXER_BLOCK_FLAG","SDS_EXER_BLOC
K_FLAG","SDS_CASH_EXER_BLOCK_FLAG","OPTION_SELL_BLOCK_FLAG","PPV_SELL_BLOCK_FLAG","SOLICITATION_FLAG","CORP_STOCK_ADMIN_CODE","BROKER_ADMIN_CODE","MODELING_BLOCK_FLAG","BLACKOUT_CASH_EXERCISE_FLAG","CLIENT_STATUS_CODE","EXCLUDE_TERM_BLACKOUT_FLAG","
EXCLUDE_TERM_ALL_BLOCKING_FLAG","RESTRICTED_STOCKS","MARGIN_ALLOWED","MARGIN_ALLOWED_FOR_INSIDERS","GRANT_TAX_FILE_SENT_DATE","SHARE_TRANSFERRED_OUT","CASH_EXER_AGREEMENT_FLAG","SDS_EXER_AGREEMENT_FLAG","SDS_CASH_EXER_AGREEMENT_FLAG","OPTION_SELL_AGR
EEMENT_FLAG","PPV_SELL_AGREEMENT_FLAG","SERVICE_TIER_CODE","RTAA_FLAG","GRANT_FILE_RECORD_COUNT","GRANT_FILE_TRUNC_ALERT_PERCENT","SPA_FILE_ALERT_LEVEL","SUPPORT_FILE_ALERT_LEVEL","SINGLE_OTS_FILE_FLAG","TRANSLATION_INSERT_FLAG","PREACTIVATION_COMME
NT","AUTO_SETTLEMENT_TYPE","NT9_INCLUSION_FLAG" from reminders
"
Please go to the end of the line from the above text (section:1 - view query). You can see the discontinuity of the column '"TRANSFER_FILTER_FLAG". It appears upto TRANSFER_FILTER_ in one line and remaining FLAG in another line which ORACLE considering 'TRANSFER_FILTER_' as column and throwing invalid identifier error while executing. It happens for all the lines.
No luck with function showlong in the below mentioned asktom URL
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:665224430110
Kindly do the needful
Regards,
Jame