Path: utzoo!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!uunet!aplcen!uakari.primate.wisc.edu!zaphod.mps.ohio-state.edu!uwm.edu!dogie.macc.wisc.edu!uwvax!ai.cs.wisc.edu!beverly
From: beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung))
Newsgroups: comp.databases
Subject: Still need help referencing globals in ORACLE SQL*FORMS triggers
Message-ID: <11240@spool.cs.wisc.edu>
Date: 12 Sep 90 16:07:13 GMT
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 34


  I am still having trouble attempting to reference a global variable
during the course of an ORACLE SQL*FORMS trigger, (v. 5)
The value a global  "curr_nucleus" is created by being assigned a value
in the form NEW2_JOIN. NEW2_JOIN calls the form "A". The pre-form trigger
of A contains the SQL statement:

	 SELECT atom_numb, atom_name
	 INTO   poss_atoms.atom_numb, poss_atom.atom_name
	 FROM   atom_lookup
	 WHERE  atom_lookup.nucleus = :global.curr_nucleus

if the last line is either

	 WHERE atom_lookup.nucleus = :global.curr_nucleus
or
	 WHERE atom_lookup.nucleus = :GLOBAL.curr_nucleus,

then I get an error during the generation of form A:

	 GLOBAL : no such block.

if the last line is either

	 WHERE atom_lookup.nucleus = global.curr_nucleus
or
	 WHERE atom_lookup.nucleus = GLOBAL.curr_nucleus

then when the form A is called I get the ORACLE error:

	 "curr_nucleus  invalid column name"

Renaming the global doesn't help.
What am I doing wrong? Are ORACLE globals not so global?