Skip to main content
Solved

Executing Stored Procedure using Sqlexecutor.

  • July 4, 2013
  • 1 reply
  • 37 views

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.

1 reply

david_r
Celebrity
  • Best Answer
  • July 4, 2013
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