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


--
Mark Harrison
Pixar Animation Studios

mh@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

On Aug 29, 2:35*am, Laurenz Albe <inv...@spam.to.invalid> wrote:
> m...@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 --