Re: PL/SQL and Data Types

Hi

To use best practices you should really declare your PL/SQL variables with %TYPE or %ROWTYPE.

pl_number1 table1.column1%type;

or

pl_row1 table1%rowtype;

Regards

Oracleguru

Ken Ankele <ankele_at_flash.net> wrote in article <01be02de$a5e9a2a0$e6c5c2d0_at_kena.aus.sig.net>...
> I have a stored procedure which takes as input a value for each column of
a
> table and merely inserts the data into the table. One of my table columns
> is defined as NUMBER. The corresponding input parameter in the stored
> procedure is defined as INTEGER. I tried to pass a FLOAT value into the
> stored procedure and got not errors. The record was successfully inserted
> into the table. Is this correct behavior, or am I missing something.
>
> Thanks,
>
> Ken Ankele
> ankele_at_flash.net
>
>
Received on Fri Oct 30 1998 - 15:08:00 CST