Re: Procedure Problem

Grinalds wrote:

> try to not use %TYPE and %rowtype, instead direct variable type or at least
> define firstly inside the package.
>
> > > procedure on_suppmst (suppcd IN po.suppmst.suppcode%type, supp_row out
> > > po.suppmst%rowtype, supp_found out boolean) is
>

I must have missed the first part of this thread but why in the world would you want to NOT use %TYPE and %ROWTYPE?

it makes maintenance easier when changing datatypes or lengths.

just my 2 cents worth, joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net (home)

Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE, drop
column script
ICQ UIN:  2832230(&oracle, home).