stored procedure

[sowmyadevi]

hi,

I am trying to call a stored procedure from data stage. While importing it in the manager, I get the following error message.
'The stored procedure SCOTT.CALLSEQ has failed to report a result set. If this stored procedure accepts parameters you may enter them below and click ok to attempt to generate a result set. Clicking the cancel accepts the current argument list but does not execute the procedure.'

If I enter a value for the argument in the argument list... I again get an error message 'identifier 'RAM' must be declared'.

I am thus not able to use procedures at all.

Kindly help me in this regard.

regards,
sowmya