ERROR for '@' for function
От | Sachin Srivastava |
---|---|
Тема | ERROR for '@' for function |
Дата | |
Msg-id | CAFzqEhKHxLnSYuGjk-q9mqN0kqBE_MUtpM2z8W8m=8=4SnH0Hg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ERROR for '@' for function
|
Список | pgsql-general |
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@REPOS.BIRCHSTREET.NET
^
********** Error **********
LINE 67: AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET
^
********** Error **********
ERROR: syntax error at or near "@"
SQL state: 42601
Character: 3274
SQL state: 42601
Character: 3274
------------------------
BEGIN
select NEXT_NUMBER into STRICT id from
AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET
--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;
select NEXT_NUMBER into STRICT id from
AUTONUMBERSETTING@REPOS.BIRCHSTREET.NET
--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;
-------------------------------
В списке pgsql-general по дате отправления: