I am going to assume that @PartNumber is your parameter for the stored procedure.
Have you tried just
I have tried that but get this error
WARN: Simple Query could not be completedMust declare the scalar variable “@PartNumber”.
You need to replace @PartNumber with the component value that you want to pass to the stored procedure.
Got it working thanks