George wrote:
>
> Wonderful! Thanks
>
> Now this opens a whole new can of worms for me.
>
> The first one to come to mind is the select * statement. I am assuming that
> this can be a lengthy operation if the table has many fields and modifying
> the table later would rise cause to modify all procedures that contain a
> select * from the modified table.
>
> Also how then does the procedure return records to the client, or does it
> not? I then surmize that using procedures to return records to the client is
> might not be the prefered method but rather a view?
>
Look up the PL/SQL ROWTYPE data type.
--
Ed Prochak
Magic Interface, Ltd.
440-498-3700(office)
Computer consulting, database and web services.
Received on Fri Jan 03 2003 - 13:04:58 CST
