Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

using "call" for packaged procedure?

 
   Database Help (Home) -> Oracle RSS
Next:  Best idiom for looping over input?  
Author Message
mh

External


Since: Jan 09, 2008
Posts: 124



(Msg. 1) Posted: Thu Aug 28, 2008 7:00 pm
Post subject: using "call" for packaged procedure?
Archived from groups: comp>databases>oracle>misc (more info?)

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

 >> Stay informed about: using "call" for packaged procedure? 
Back to top
Login to vote
Laurenz Albe

External


Since: Jan 11, 2008
Posts: 54



(Msg. 2) Posted: Fri Aug 29, 2008 6:35 am
Post subject: Re: using "call" for packaged procedure? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

 >> Stay informed about: using "call" for packaged procedure? 
Back to top
Login to vote
Mark D Powell

External


Since: Dec 20, 2007
Posts: 259



(Msg. 3) Posted: Fri Aug 29, 2008 6:50 am
Post subject: Re: using "call" for packaged procedure? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Aug 29, 2:35 am, Laurenz Albe <inv....RemoveThis@spam.to.invalid> wrote:
> m....RemoveThis@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 --
 >> Stay informed about: using "call" for packaged procedure? 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Oracle All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]