Reputation: 81
I have created a simple procedure in Informix Database.
I am able to run this procedure from Data Studio (Informix Development Tool) and the procedure is executed successfully.
But, when i try to execute the same procedure from "SYSADMIN --> ph_task" or "Open Admin Tool" I am getting an error " -556 Cannot create, drop or modify an object that is external to the current database ".
Here i have mentioned only test code.
If a get the solution then i will use it accordingly in my original code.
CREATE PROCEDURE neura_practice_dev.proc_test()
create table neura_practice_dev@inst_13:proc_test_tbl(id smallint);
END PROCEDURE;
Upvotes: 0
Views: 29