Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!uwm.edu!uwvax!ai.cs.wisc.edu!beverly
From: beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung))
Newsgroups: comp.databases
Subject: Can one reference global vars in SQL stmts in ORACLE SQL*Forms?
Message-ID: <11212@spool.cs.wisc.edu>
Date: 10 Sep 90 19:18:21 GMT
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 19


   In one of my triggers I have an SQL statement that refers to a
   global var:

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

								  ******



   When the trigger gets triggered I get an error msg saying that 
   curr_nucleus is an invalid column name. Changeing the column name
   doesn't  help.  THe value of global.curr_nucleus was set up by
   a form that called this one. In the SQL*Forms manuals there are
   no examples of use of global vars in SQL. Is it allowed?