Re: PL/SQL help needed

... Also any ideas on how I can get the policy number from the cursor into a variable? ..

that is what he is showing here, using pseudo code - if i follow, it's read like fetch field expression n into var list n, like fetch id, name into idvar, namevar

i am still stuck in mssql land, my oracle is weak, but you declare the vars to match the field structure....

brent

>>LOOP
>> FETCH C1 INTO R1;
>> EXIT WHEN C1%NOTFOUND;
.......
>>
>>end loop;
>>commit;
>>end;
>>
>>
Received on Tue Jul 27 1999 - 12:25:42 CDT