Executing stored procedure along with DAta Deploy

System

Hi,

I am trying to execute a stored procedure along with the normal data deploy but none of the deployment is working, but the status is shown as completed.

I am attaching the DD config file along with the post.

There are in all 4 deployments defined in the config file.
Two of them (basearea and content) are normal DD definitions and the third one (stored) is for executing stored procedure.

The fourth one calls the other three deployments and execute them.
as shown below.

deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
exec-deployment use="stored"/
/deployment

Now when i execute the following commands
-----------------------------------------------------------------------
1) iwodcmd start product_dddeploy10 -k iwdd=multi -k [some other parameters that are required are passed]

In this case if my "multi" definition is as follows
=======================================
deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
/deployment
=======================================

Then above scenario works perfectly fine.
-----------------------------------------------------------------------

2) iwodcmd start product_dddeploy10 -k iwdd=stored -k iwdd-op=do-sql -k user-op=execute_my_procedure -k [some other parameters that are required are passed]

In the above command i directly call the 'stored' deployment definition and the stored procedure executes fine.

-----------------------------------------------------------------------

In third case when i combine the above the deployment is shown as success but there is not data transferred.

3) iwodcmd start product_dddeploy10 -k iwdd=multi -k iwdd-op=do-sql -k user-op=execute_my_procedure -k [some other parameters that are required are passed]


and use
=======================================
deployment name="multi"
exec-deployment use="basearea"/
exec-deployment use="content"/
exec-deployment use="stored"/
/deployment
=======================================
In this case no data is deployed but the deployment status is shown as success

-----------------------------------------------------------------------


I know the post is too big but... couldn't have described the issue i am facing.

Can somebody help me on this???

thanks
-Dixit

TS 6.5
Windows
Opendeploy 6.0