> When I do this I get an error "FieldName: pSuccess not found". The
> component must need the return parameter defined somewhere.

Strange. I have one erratum:

dsql.sql := ...
must be: dsql.sql.clear;
dsql.sql.add('......

I've run a test which worked ok (without extra settings).
Are you sure 'psuccess' equals the name of the sp's outputpar?
How does the sp look like?