Re: Problem in Get_Block_property(blk_id, ORDER_BY)

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/12/03
Message-ID: <19971203175901.MAA06865_at_ladder02.news.aol.com>#1/1

Hi.

Here's your problem

>DECLARE

 >order_by VARCHAR2(200);
> blk_id Block

ORDER_BY is a NUMERIC CONSTANT (it has a value of 181)

I reckon there is a bug in that you are allowed to overide a constant.

avoid this and other problems by always using a prefix for your own variable

v_Order_by for example

and p_Employee_id for a parameter

Regards
John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

. Received on Wed Dec 03 1997 - 00:00:00 CET