Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when "Execute Statement ... on external data source" done under trusted authentication without "As user ... PASSWORD ... ROLE .." parameters [CORE5344] #5618

Open
firebird-automations opened this issue Sep 1, 2016 · 0 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: ded Rasta (dedrasta)

Connect with database as trusted user ( current_user = 'domain\user' ) and execute following code:

execute block
returns ( p01 timestamp )
AS
declare variable s varchar(2000);
begin
S = 'select current_timestamp from rdb$database';
execute statement (:S)
-- as user 'SYSDBA'
-- password 'masterkey'
on external data source 'inet4://LOCALHOST:3052/EMPLOYEE_FB3'
into :p01;
suspend;
end

Got following error:

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Internal error when using clumplet API: attempt to store 268 bytes in a clumplet with maximum size 255 bytes.

When uncommenting user and password parameters code executes without error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant