Documentation / Tutorial needed

From: Jens Riedel <JensRie_at_gmx.de>
Date: Tue, 18 Sep 2007 10:26:56 +0200
Message-ID: <5l9gerF74h4rU1@mid.individual.net>

Hi,

I have to do some work in a project where a former colleage used Oracle procedures.

They look like this:

PROCEDURE delete_product (

         i_crm in products.products_crm%TYPE
     ) IS
         my_products_id products.products_id%TYPE;
         my_products_attr_id 

products_attributes.products_attributes_id%TYPE;
....

     BEGIN
         init;
         if i_crm is null or length(i_crm) <=0 then
             raise_application_error(-20001, 'product crm invalid!');
         end if;

....

Where can I find online documentation which teaches me how this works? I can guess what most of the things mean, but details like '%TYPE' are probably important... ;-)

Thanks for any hints,
Jens Received on Tue Sep 18 2007 - 03:26:56 CDT