 |
|
 |
|
Next: Best idiom for looping over input?
|
| Author |
Message |
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 |
|
 |  |
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 |
|
 |  |
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 |
|
 |  |
|
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
|
|
|
|
 |
|
|