Hello,
Within the package, there's a complex procedure that's interconnected with other procedures, forming a cascade of calls. The central procedure is triggered by the script.sh file. This script is responsible for handling files, while the procedure manages individual records from these files. I'm looking for guidance on utilizing tools like Toad or SQL Developer to facilitate a step-by-step examination of the code. My goal is to gain insight into the processing of these records. I came across the concept of remote session debugging, but I'm uncertain about the specific configuration required to set it up effectively.
I appreciate any help!