Re: using "call" for packaged procedure?
Date: Fri, 29 Aug 2008 06:50:28 -0700 (PDT)
Message-ID: <632e5c3d-ae6f-45d1-8bbe-4a42847c2285@l42g2000hsc.googlegroups.com>
On Aug 29, 2:35 am, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> m..._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- Hide quoted text -
>
> - Show quoted text -
Mark, it took me a couple of readings but it does appear that Laurenz is pointing out that your spelled the package name different in your example of what failed and what worked. Based on this the error message was telling you the truth. Be there, done that. LOL.
It is time for the weekend!
HTH -- Mark D Powell -- Received on Fri Aug 29 2008 - 08:50:28 CDT