Stored Procedure Stage - how does it work?
Posted: Thu Mar 31, 2005 9:19 am
I have a situation where I believe I would benefit from using a Stored Procedure Stage, but I find the documentation to lack any detailed description of this stage. The online help file STPgui.HLP is missing in my installation and in the pdf files there's not much either.
What I need to do is use a stored procedure to input data rows to a table; this is desired for consistency reasons, and it seems logical to use a Stored Procedure Stage to do this.
I get an Ora Error message as follows:
<JobName>..<StageName>: ORA-06550: line 1, column 7: PLS-00201: identifier '<SCHEMA>.<PACKAGE>' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
where <SCHEMA>.<PACKAGE> is the package where the procedure is defined. Do I need to put the procedure directly in the schema as a 'free' procedure not in a package, or is this a sign of something else being weird?
And what is the difference between the Data Source and the Database Name properties in the STP compared to the single Database Source Name property in a regular Oracle stage?
What I need to do is use a stored procedure to input data rows to a table; this is desired for consistency reasons, and it seems logical to use a Stored Procedure Stage to do this.
I get an Ora Error message as follows:
<JobName>..<StageName>: ORA-06550: line 1, column 7: PLS-00201: identifier '<SCHEMA>.<PACKAGE>' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
where <SCHEMA>.<PACKAGE> is the package where the procedure is defined. Do I need to put the procedure directly in the schema as a 'free' procedure not in a package, or is this a sign of something else being weird?
And what is the difference between the Data Source and the Database Name properties in the STP compared to the single Database Source Name property in a regular Oracle stage?