Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS-00201 after long running procedure call
<peter_kuehn_at_hotmail.com> schreef in bericht
news:1164651241.192121.278320_at_14g2000cws.googlegroups.com...
> [...]
>> Peter,
>>
>> Do you, by accident, change user/schema in your procedure
>> sap2ora.post_actions, or disconnect? This because you write data to a new
>> schema.
>> Or does your package become invalid?
>> Hard to tell what's wrong without the complete script; or at least the
>> last
>> few lines (but I'm not a perl expert anyway...)
>> Just to check: what happens if you put an extra call AFTER
>> sap2ora.log_stop
>> (e.g. put it there twice, see if it fails in the first or second call)?
>> (To
>> check if nothing is wrong with the last line syntax).
>>
>> Shakespeare
> Hi,
>
> found a workaround by qualifying the package name with schema name.
> Maybe it had to do with the fact that there was a package call of
> another user
> just before:
>
> [Perl Skript] [sap2ora pkg] [kvby_stamm pkg]
>
> --> do anything
> ...
> log_info --> write_log
> <--
> <--
> sap2ora.log_stop: crash
>
> but mis_src.sap2ora.log_stop works fine (I'm connected as mis_src!!)
>
> Thanx, Peter
>
Could be a faulty synonym; but hey: it works!
Shakespeare
(what's in a call?)
Received on Mon Nov 27 2006 - 15:23:49 CST