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

Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql table and commit

Re: pl/sql table and commit

From: Guy <guhar1_at_yahoo.com>
Date: 16 Nov 2005 12:45:31 -0800
Message-ID: <1132173931.572324.160010@g47g2000cwa.googlegroups.com>


Rats to me !@#$%

Its the dams EXISTS which never returns true   ASP42.tab_ClinicUser.EXISTS(R1.r_clinic)

The code which loads "tab_ClinicUser" is defined at the end of my 2000+ packages body definition, after all proc definition?

BEGIN
   FOR rec_clinic IN (SELECT clinic_code from AS_T_CLINICS ORDER BY 1)    LOOP
      tab_ClinicUser(rec_clinic.clinic_code) := rec_clinic;   END LOOP;
END; How does this code gets executed? And when ? When I "replace or create" the package ? Received on Wed Nov 16 2005 - 14:45:31 CST

Original text of this message

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