2 Replies Latest reply on Jul 27, 2012 4:28 PM by 952056

    How I can read a table and for each record read execute a procedure?


      I'm working on a DB Oracle / Microsoft Windows 7 Enterprise (development environment).

      I am a beginner in programming PL / SQL. I'm trying to create a program that reading all the records in a table and for each record run a procedure.

      The table contains connection strings to databases and for each record read connect to a db, once the connection is made to run processes that produce performance reports, size, etc.

      Can you suggest any way?

      Thanks for help