Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help: Table Name Substitution with a variable

Help: Table Name Substitution with a variable

From: Madsal <softsense_at_home.com>
Date: Mon, 04 Oct 1999 19:29:10 GMT
Message-ID: <37F90117.35F805ED@home.com>

     I have the following procedure....
     
         LOOP
             FETCH table_cur INTO table_rec;
             EXIT WHEN NOT table_cur%FOUND;
     
             TableID := table_rec.TableName;
             Office := table_rec.OfficeNum;
             Client := table_rec.CliNum;
     
             IF Office = 'Y' AND Client = 'Y' Then
             UPDATE TableID
             SET OfficeNum = (SELECT OfficeNum 
                              FROM Comd02a                           
                              
     WHERE Comd02a.CliNum = TableID.CliNum
                              AND Comd02a.LoanNum = TableID.LoanNum);
     
         END IF;
         END LOOP;
         CLOSE table_cur;
     
     TableID is a vaiable and I keep coming back with an error... How 
     do I make a reference to a table through a variable...
     
     Thanks in Advance
     Sally
Received on Mon Oct 04 1999 - 14:29:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US