Re: PLS-00201 after long running procedure call

<peter_kuehn_at_hotmail.com> schreef in bericht news:1164039512.638366.93970_at_h48g2000cwc.googlegroups.com...
> Hi,
>
> we use a Perl script to transfer SAP data via RFC into a oracle
> database (9.2.0.7).
> The db access is mainly implemented as a series of calls to a db
> package (sap2ora).
> Perl pseudo code looks like this:
>
> ...
> &"call sap2ora.log_start;"
> &"read konfig data from tables tab_konfig and rep_config"
> &"call sap2ora.pre_actions;"
> &"foreach tab_config entry read SAP info type and write data into
> oracle staging area"
> &"foreach rep_config entry read output of SAP report and write data
> into oracle staging area"
> &"call sap2ora.post_actions; -- runs about twenty minutes"
> # error in next statement
> &"call sap2ora.log_stop(0, 'ok');"
>
> DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
> PLS-00201: identifier 'SAP2ORA.LOG_STOP' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator
> at char 6 in 'begin <*>sap2ora.log_stop(:p1, :p2); end;') [for
> Statement "begin sap2ora.log_stop(?, ?); end;" with ParamValues: :p1=0,
> :p2='ok'] at ./sap2ora.pl line 293, <INFILE> line 1.
>
> there is nothing wrong with sap2ora.log_stop, the get the same error
> message if I replace
> log_stop with any other procedure eg. log_start:
>
> PLS-00201: identifier 'SAP2ORA.LOG_START' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator
> at char 6 in 'begin <*>sap2ora.log_start; end;') [for Statement "begin
> sap2ora.log_start; end;"] at ./sap2ora.pl line 280, <INFILE> line 1.
>
> sap2ora.post_actions performs the following actions: it loads data from
> the current schema,
> transforms and writes it to another schema with pl/sql-logic, executes
> owb-mappings and
> analyses the current schema before and destination schema after the
> transformation.
> All works very well. But the last step (log_stop) fails. I'm out of
> ideas 8-((
>
> Please help.
>
> currently we use the following Perl modules:
> DBI 1.48
> DBD 1.16 (Oracle)
> SAP-RFC 1.40
>
> Ciao, Peter
>

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 Received on Tue Nov 21 2006 - 04:19:35 CST