I am having problems calling an Oracle Stored Procedure from an Access 97 database. The SP is called FIRST_TREATMENT which is in a schema called CCMGR, and accepts 2 parameters. I have used the following code directly into Oracle, which works fine:

BEGIN
CCMGR.FIRST_TREATMENT ( 'RGU00/00481', NULL );
END;


However, I can't seem to call the SP from Access 97 ina pass through query. I have tried the following, with no success:

EXEC CCMGR.FIRST_TREATMENT ( 'RGU00/00481', NULL );

or

EXECUTE CCMGR.FIRST_TREATMENT ( 'RGU00/00481', NULL );

or

{
CALL CCMGR.FIRST_TREATMENT ( 'RGU00/00481', NULL );
}

or

{call ?=CCMGR.FIRST_TREATMENT ( 'RGU00/00481', NULL )}

ANY HELP ON THIS WOULD BE GRATELY APPRECIATED.

Thank you

Simon