Re: Why these two methods using cursor to acquire table_name and then using this table_name to select its returned lines is always encoutered a weird error?
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Thu, 9 Dec 2021 09:25:41 +0000
Message-ID: <AS8P193MB17502907C9D0897BBA28A7BDA1709_at_AS8P193MB1750.EURP193.PROD.OUTLOOK.COM>
Date: Thu, 9 Dec 2021 09:25:41 +0000
Message-ID: <AS8P193MB17502907C9D0897BBA28A7BDA1709_at_AS8P193MB1750.EURP193.PROD.OUTLOOK.COM>
Hello my friends 😊,
I've written two anonymous plsql blocks checking those tables (starting with "DBA_HIST_" in SYS schema of oracle database) returned line is 0, but it's always encountered an error.
Here's my PL/SQL code:
- https://gist.github.com/guestart/1e0f49089530564a9f7c01b015416ad7<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgist.github.com%2Fguestart%2F1e0f49089530564a9f7c01b015416ad7&data=04%7C01%7C%7Cd2370777d24441a76a3d08d9baee641d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637746355363757193%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=5yU%2Bl1TgiUOmN8amufJ4FfeeBeIAJJMsvzIA21J6zrs%3D&reserved=0>
- https://gist.github.com/guestart/0ca72e5344aa3ecaf26b905337e1dcd8<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgist.github.com%2Fguestart%2F0ca72e5344aa3ecaf26b905337e1dcd8&data=04%7C01%7C%7Cd2370777d24441a76a3d08d9baee641d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637746355363757193%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=KyTmIN0ndxmj3Ou4Q%2BDj6xgNXJn2C5HDrQD27L4CeBI%3D&reserved=0>
Could you help me troubleshooting it? Thanks beforehand 🙏.
Best Regards
Quanwen Zhao
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 09 2021 - 10:25:41 CET