PL/SQL help with loops, method and explanation for Pl/SQL loops

[sqlsurf]

All,

I am new to PL/SQL and just can't seem to get the syntax right.

I am a PL/SQL newbie trying to create a package that will get a result (ID) from a query from two tables and then turn around and loop through the one or more records found and do an insert into a another based on
a select from the previous query. This is what I have now:



DECLARE
rec_clarity_tdl clarity_tdl%ROWTYPE
rec_clarity_ser clarity_ser%ROWTYPE


BEGIN

CURSOR my_cursor IS

SELECT performing_prov_id from clarity_tdl
MINUS
SELECT not in clarity_ser_billing;
--returns performing_prov_id
--550130


LOOP

FOR prov_rec IN my_cursor
INSERT INTO provider_addl
VALUES (select * from provider where provid = prov_rec
-- one record by one from cursor
END LOOP;

END
/

[davey23uk]

whats the problem you are having?

[sqlsurf]

Simply put, I am trying to get the results of one query and use it loop through and put it into an insert on another table.

[davey23uk]

so what's the problem? all you have done is put some code down and not said what the problem with it is

[sqlsurf]

I am trying to create a package that will get the results of a query (a field on a table) and then turn around and get those results and plug them into a looping insert stmt on another table. Do I declare both tables?

[PAVB]

define "declare"

[sqlsurf]

Declaring the two tables I need under the declare section with %ROWTYPE...

[PAVB]

why would you do that?

I understand your business logic is something like 1) load a cursor -where you have to declare something then 2) loop into the cursor inserting into a second table something you get from a third table. Is that correct?