enrique_aeo
asked on
insert with dblink
Experts, good afternoon:
I need your support with a downside I have to insert user data on another server database, I have configured my link server correctly and I am creating a stored procedure to insert into multiple tables but only when inserted in the table users (tab_usuario) I get the error that can display image to the other tables I have no error.
I was doing my research and among them found it can be for any restriction of the target table (tab_usuario) but I do not find any problem with constrains or keys, can also be by the pull of transactions but when I do it for another insert in a separate table no problem
image.png
tab-usuario.sql
usp-ps-EqMovilesWeb.sql
I need your support with a downside I have to insert user data on another server database, I have configured my link server correctly and I am creating a stored procedure to insert into multiple tables but only when inserted in the table users (tab_usuario) I get the error that can display image to the other tables I have no error.
I was doing my research and among them found it can be for any restriction of the target table (tab_usuario) but I do not find any problem with constrains or keys, can also be by the pull of transactions but when I do it for another insert in a separate table no problem
image.png
tab-usuario.sql
usp-ps-EqMovilesWeb.sql
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Attached the error and the portion of code that causes the error
Error-Script.sql
image.png