Solved
Executing Stored Procedure using Sqlexecutor.
I am facing problems while executing parameterised stored procedure using sql executor. Error log prints the error statement with parameter values, and when I use the same statement to execute directly in oracle, it runs properly.
Best answer by david_r
Hi,
have you tried somthing like this?
begin
my_stored_proc(
proc_param_a => '@Value(my_attribute_a)',
proc_param_b => '@Value(my_attribute_b)'
);
end;
If that still does not work, consider posting more details.
David
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
Hi,
have you tried somthing like this?
begin
my_stored_proc(
proc_param_a => '@Value(my_attribute_a)',
proc_param_b => '@Value(my_attribute_b)'
);
end;
If that still does not work, consider posting more details.
David
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.