2 Replies Latest reply: Jul 27, 2012 11:28 AM by 952056 RSS

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

    952056
      Hello,

      I'm working on a DB 11.2.0.1.0 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