Retail Predictive Application Server (MOSC)

MOSC Banner

create_staging_tables() in RDM

edited Jan 17, 2017 4:00AM in Retail Predictive Application Server (MOSC) 5 commentsAnswered

Hi,

what's the correct syntax of the create_staging_tables function ?

I've shared opclusterlabel measure in RDM and now want to create staging tables for a fact opclusterlabel (see pic.).

Seems I do something wrong.

I tried to run:

execute rpas_data_mart_apos.rp_etl_pkg.create_staging_tables("opclusterlabel" ,2 );

or

execute rpas_etl_user_apos.rp_etl_pkg.create_staging_tables("opclusterlabel" ,2 );

in both cases I get:

Error starting at line 201 in command:

Error report:

ORA-06550: line 1, column 60:

PLS-00201: identifier 'opclusterlabel' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Thanks,

Andrey.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center