Subject Re: [firebird-support] how to accessing table in another database from stored procedure
Author Yohanes Ongky Setiadji
Hi Alex,

I install new Firebird 2.5 and tried to use EXECUTE STATEMENT in my
database, but the result is:

Internal error when using clumplet API: attempt to store data in
database clumplet...

BTW, my database was created using Firebird 2.13.

Any suggestion?

Thanks in advance.


On 8/23/10, Alexandre Benson Smith <iblist@...> wrote:
> Em 22/8/2010 23:34, Yohanes Ongky Setiadji escreveu:
>> Hi all,
>> I have 2 database.
>> One to store the daily transaction (A) and another to store the security
>> (B).
>> When users logon, they only connected to the database A.
>> Is there a way to connect to the database B from stored procedure in
>> database A?
>> I want to collect user data like username and password that saved in
>> database B but
>> user must not be able to connect directly to database B.
>> So I want to create stored procedure in database A to do the job.
>> Thanks,
>> Ongky
> In FB 2.5 yes.. take a look on the release notes for the new features of
> execute statement.
> see you !