SQL:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
mobile_num from LOADED_MOBILE_NUMBERS)
You can try this:
update SUBSCRIPTIONTABLE, LOADED_MOBILE_NUMBERS set
SUBSCRIPTIONTABLE.ACTIVEFLAG='Y'
where LOADED_MOBILE_NUMBERS.mobile_num=SUBSCRIPTIONTABLE.mobile_num
Anatoly.
Anatoly Okishev wrote:
How the function written on pl/pgsql can be called by the function
written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.
You probably need to be calling "SELECT get_national_code(...)" to access
it
How the function written on pl/pgsql can be called
by the function written on plperl.
Error is:
error from function: Undefined subroutine
&Safe::Root2::get_national_code called.