>>The profile I'm using has the proper rights to the Oracle tablespace.
>
>Yes, but can it see the procedure? Does the profile have a Synonym to the SP?
>It is a pian setting this up, but it is good security.

I'll check with the Oracle DBA, but if I can run the stored procedure using my profile from the SQL*Plus command line, doesn't that mean that the SP already has a synonym for my profile?