Re: using "call" for packaged procedure?

mh_at_pixar.com wrote:
> After moving a procedure into a package I discovered I can
> no longer use "call" to invoke the procedure.
>
> Can someone explain why this is?
> Many TIA!
>
>
> old code:
>
> call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp)
>
> new code (broken):
>
> call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp)
>
> ORA-01747: invalid user.table.column,table.column,
> or column specification
>
> new code (works):
>
> begin p4asset.add(:typename,:repos,:depotFile,:rev); end

Are there typos in your posting?

Because if not, then the solution would be obvious:

CALL p4asset.add(:typename,:repos,:depotFile,:rev);

Yours,
Laurenz Albe Received on Fri Aug 29 2008 - 01:35:18 CDT