Symptoms

I am trying to call a Oracle stored procedure using a SmartObject auto generated from the service instance object. I get an error (see attachments) when testing from SmartObject tester but the stored procedure works in SQLplus. Another developer on my team was unable to use a SmartObject that he created off his stored procedure.
 

Diagnoses

The Oracle code was missing a synonym.
 

Resolution

When attempting to call a stored procedure as a user who did not create the procedure, you have you create a public synonym specifically for the procedure for it to work.