Forum Stats

  • 3,839,868 Users
  • 2,262,546 Discussions
  • 7,901,087 Comments

Discussions

set default value in text field page item

Anjlesh Rai
Anjlesh Rai Member Posts: 17

Hi All,

I am try to set default value through condition.my code for default value is:

begin

select

CASE

when ip IN('192.168.1.101','192.168.1.100','192.168.1.102') THEN :P50_SALES_TYPE:='CA'

else

when ip IN('192.168.1.103','192.168.1.105') THEN :P50_SALES_TYPE:='CR'

END

from ip

end ;

and default value type is pl/sql expression

ip is a table in which ip column contains all ip address used in case statement.after apply changes i am getting following error

ORA-06550: line 2, column 1: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new not null   continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date    pipe

    Error    ERR-9132 Error in PLSQL expression for item default code, item=P50_SALES_TYPE

OK       

anyone have idea of this type of problem.

please let me know.

thanks.

This discussion has been closed.