Re: Oracle Form - ORDER BY clause

[Quoted] [Quoted] It is my understanding that you cannot use a function in the ORDER BY clause of a base table block - only a column name belonging to the base table or a form item.

Geoff

suisum_at_ecn.ab.ca wrote:

> I have the following tables. I want to get a list of movie rentals in
> movie title for a particular customer. I have created the following
> function in Oracle Form for sorting purpose:
>
> FUNCTION sort_movie_title_fn
> (p_tape_id NUMBER)
> RETURN VARCHAR2
> <snip>

> However, when I put the following clause in the Rentals ORDER BY clause
> property, the form complains the invalid column name. I believe the error
> is the tape_id.
>
> sort_movie_title_fn (tape_id)
>
> Please help.
> <snip>
Received on Thu Apr 22 1999 - 06:35:59 CEST