Calling Dynamic SQL Dynamically? How to,

  Any useful help greatly appreciated.

 

I am trying to develop code to launch a Package.Procedure dynamically. If possible, I would like to return a value/parm, but not necessary at this point. I see plenty examples on the internet, but I have not been able to get them to run using the developer tools at my facility.

 

Two questions:

 

1. Can dynamic sql be executed in SQLDeveloper or SQLPlus? Need help understanding how to test in Oracle environment.

 

2. I am attempting to call test.procedure using below anonymous block in SQLDevloper, but continually get error messages. Note: I eventually will need to the statement turned into a string call. (string := ‘package’ || ‘procedure’ concept.) For now...taking baby steps.