Home » Developer & Programmer » Warehouse Builder » Problem deploying a post procedure in a mapping (OWB 11GR2, Windows XP 32bit in VMBox)
Problem deploying a post procedure in a mapping [message #508178] Thu, 19 May 2011 13:28 Go to next message
ilharco
Messages: 8
Registered: March 2011
Location: Portugal
Junior Member
Hy everyone,

I have a mapping to a clients TABLE that has 4 sources:
- CUSTOMERS (from a relational DB in anoher machine)
- COUNTRIES (from a relational DB in anoher machine)
- DEMOGRAPHY (from my DW stage area)
- SALES (also from a relational DB in anoher machine)

I have a joiner, the condition seems good, but I have to update/insert the client's last buy in CLIENTS tabel in the DW.

SO, i did a post-procedure with the following code:
http://pastebin.com/FJQ1YBe6

But, when I deploy it gives this warnings:
Deployment
            ORA-06550: PROCEDURE, line 6, column 13:
PL/SQL: ORA-00942: table or view does not exist
            ORA-06550: PROCEDURE, line 5, column 3:
PL/SQL: SQL Statement ignored
            ORA-06550: PROCEDURE, line 16, column 51:
PL/SQL: ORA-00942: table or view does not exist
            ORA-06550: PROCEDURE, line 16, column 5:
PL/SQL: SQL Statement ignored
            ORA-06550: PROCEDURE, line 18, column 33:
PLS-00364: loop index variable 'CS' use is invalid
            ORA-06550: PROCEDURE, line 18, column 33:
PL/SQL: ORA-00904: "CS"."CUST_ID": invalid identifier
            ORA-06550: PROCEDURE, line 17, column 5:
PL/SQL: SQL Statement ignored
            Create Succeeded


Can you please help me to see if something is missing or wrong in the procedure?

Tks in advance.

Another noob...
Re: Problem deploying a post procedure in a mapping [message #508181 is a reply to message #508178] Thu, 19 May 2011 14:03 Go to previous message
Michel Cadot
Messages: 58618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either the table does not exist (where you try to reach it which may not be where you think you do) or you have not the privilege to access it in the context you want to access it.

Regards
Michel
Previous Topic: The specified location parameter is not valid
Next Topic: Problems deploying and executing with a user with proper tablespace
Goto Forum:
  


Current Time: Wed Jul 30 08:09:42 CDT 2014

Total time taken to generate the page: 0.14196 seconds