Re: Set Block Property in Oracle

Shaju.francis_at_in.bosch.com
Hi,
Create a item ssno inthe non batabase block and inthe property 'Copy value from Item'
give database block item, this will work. try.

amitabh12_at_my-dejanews.com wrote:

> 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 Fri Mar 19 1999 - 05:58:52 CST