SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

952056Jul 27 2012 — edited Aug 1 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2012

Added on Jul 27 2012

11 comments

361 views