But if I can run this exact same command in SQL*Plus and get the correct results, wouldn't t his mean it was not a permissions problem?


>Sounds like you don't have permission to access the charge table in the schema
>where you are creating the procedure...
>
>Try something like
>
>connect FNBAA/password
>grant select on charge,charge_definition to schema_for_procedure;