Re: PLS-00201 after long running procedure call

From: <peter_kuehn_at_hotmail.com>
Date: 27 Nov 2006 10:14:01 -0800
Message-ID: <1164651241.192121.278320@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 Received on Mon Nov 27 2006 - 12:14:01 CST