Re: Documentation / Tutorial needed

On Sep 18, 3:26 am, Jens Riedel <Jens..._at_gmx.de> wrote:
> 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

http://tahiti.oracle.com

is the source of the Oracle on-line documentation. Also google for Steven Feuerstein as he is a respected authority for PL/SQL programming. His text, "Oracle PL/SQL Programming, 4th ed." is, in my mind, required reading.
The ISBN-10 is 0-596-00977-1; the ISBN-13 is 978-0-596-00977-9.

David Fitzjarrell Received on Tue Sep 18 2007 - 08:17:15 CDT