Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Set Block Property in Oracle
hi,
I have a non database block and when I put in the following trigger
it doesnt return anything.
GO_BLOCK('name of the database block');
SET_BLOCK_PROPERTY('name_of_the_block',DEFAULT_WHERE,'ssno < :ssno');
EXECUTE_QUERY;
but now if I do the following it works :GLOBAL.ssno = :ssno;
GO_BLOCK('name of the database block');
SET_BLOCK_PROPERTY('name_of_the_block',DEFAULT_WHERE,'ssno < :GLOBAL.ssno');
EXECUTE_QUERY;
Any reason why is that, and secondly if anyone knows how to make it work
without using Globals I would really appreciate their help
Thanks
Munish
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 18 1999 - 12:01:18 CST