I have a proc in oracle that runs perfectly. Tried to run from SQL Server but get error.

Execute OracleServer..Myschema.ProcName

Get error Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ProcName' on remote Server 'OracleServer'

I can query the remote server just can't run the proc. Again the proc runs in Oracle without any errors.