Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PLS-00201 after long running procedure call

PLS-00201 after long running procedure call

From: <peter_kuehn_at_hotmail.com>
Date: 20 Nov 2006 08:18:32 -0800
Message-ID: <1164039512.638366.93970@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 Received on Mon Nov 20 2006 - 10:18:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US