Re: Calling into other database fails with "Not implemented yet"
Posted in 2003
There are some serious issues with 9.21 (check in this forum). You should upgrade to newer version.
"Maks Romih" <maks.romih@snt.si> wrote in message news:u65joc1dz.fsf@snt.si...
> From dbaccess I execute a stored procedure that is defined in another
> database on the same Informix 9.21 server with
>
> execute procedure my_db2:proc1(...);>
> I get the reply
>
> 999: Not implemented yet.>
> If I then connect to that other database my_db2 and execute the same
> statement from there, it works fine. But, strangely, when I afterwards
> connect back to the first database, it works fine as well.
>
> It seems that as soon as I restart the server, I have to at least once execute
> all my procedures by connecting to the very database, where they are defined.
>
> It seems that the procedure "is lost" also if I DROP and CREATE it.
>
> What is happening here?
>
> Is there any other way to assure that stored procedures are "known" to
> other schemas?
>
> Maks Romih