Search Postgresql Archives

ERROR for '@' for function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



How to handle this below situation, I am getting error for function, my  Postgres version is 9.4
 is

ERROR:  syntax error at or near "@"
LINE 67:   AUTONUMBERSETTING@xxxxxxxxxxxxxxxxxxxxx
                            ^
********** Error **********
ERROR: syntax error at or near "@"
SQL state: 42601
Character: 3274


------------------------

BEGIN
  select NEXT_NUMBER into STRICT  id from
  AUTONUMBERSETTING@xxxxxxxxxxxxxxxxxxxxx
  --pbeach_repos8.AUTONUMBERSETTING
  where subscriber_id=subscriber and AUTO_NUMBER_ID=348 and company_id= buyer;
   exception
  when no_data_found then
       insert into smerror_log(error_log_id,subscriber_id,company_id,error_message,system_message,
       method_name,creation_date,creation_user,update_date,update_user)
     values (nextval('smerror_log_sequence'),subscriber,buyer,'Auto Number not found',null,
       'PunchoutProfile'  ,LOCALTIMESTAMP,'Admin',LOCALTIMESTAMP,'Admin');
       commit;
      return;
  end;

-------------------------------


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux