Shangeetha
Shangeetha

Reputation: 81

Informix DB " -556 Cannot create, drop or modify an object that is external to the current database "

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.

Sample Procedure

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

Answers (0)

Related Questions