Re: PL/SQL problem in forms v4.5

In article <336FAF0C.A4FE06B4_at_ceiss.org>   Drew Leske <dleske_at_ceiss.org> writes:

Create_Group_From_Query is a function returning RECORDGROUP. It returns a record group ID.

Populate_Group is a function returning BOOLEAN. It returns 0 if successful and an error number if not.

Try:

DECLARE

	rg_id	RECORDGROUP;
	statusb	BOOLEAN;

BEGIN

	rg_id := Create_Group_From_Query( ... );
	statusb := Populate_Group( ... );
	Populate_List( ... );
	...
	Delete_Group( rg_id );

END;
> using Forms v.4.5.7.1.6 (including PL/SQL Version 1.2.1.5.0):
>
> I am an initiate into the land of Oracle, and I'm having some trouble
> with a form of mine (my first actually). I want to fill a list box with
> some data from a table and for this I am using
> Create_Group_From_Query ( ... )
> Populate_Group ( ... )
> Populate_List ( ... )
> My problem is that execution dies on the first two lines, although the
> third seems to cause no problems. All three subprograms appear in the
> "Standard Extensions" branch of "Built-in Packages" in the object
> navigator, but only Populate_List is recognized. The other two get the
> following error: "'CREATE_GROUP_FROM_QUERY' is not a procedure or is
> undefined".
>
> Any ideas?
>
> Drew Leske
> dleske_at_ceiss.org
>

-- 
-------------------------------------------------------
| Andrew G. Tompkins    | #include <disclaimer.std.h> |
| Software Design Eng.  ------------------------------|
| Tektronix, Inc.                                     |
| Phone: (503) 627-5172      fax: (503) 627-5548      |
| email: Andrew.Tompkins_at_tek.com (work)               |
|        andytom_at_teleport.com (home)                  |
| http://www.teleport.com/~andytom/                   |
-------------------------------------------------------