Re: pl/sql conditional problem

in oracle strings are representes in single quotes and doulble quote is mistook for a column name

Martin Meadows wrote:

> Who knows why the following won't compile in sqlforms30:
>
> if :hlpchk = "X" then
> show_page(2);
> else
> raise other;
> end if;
>
> The error msg indicates that "X" is an undeclared identifier. I thought
> that it was a string!
>
> Martin Meadows

Martin Meadows wrote:

> Who knows why the following won't compile in sqlforms30:
>
> if :hlpchk = "X" then
> show_page(2);
> else
> raise other;
> end if;
>
> The error msg indicates that "X" is an undeclared identifier. I thought
> that it was a string!
>
> Martin Meadows

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)