Set Block Property in Oracle

From: <amitabh12_at_my-dejanews.com>
Date: Thu, 18 Mar 1999 18:01:18 GMT
Message-ID: <7crf1a$vrp$1@nnrp1.dejanews.com>

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