| Problem deploying a post procedure in a mapping [message #508178] |
Thu, 19 May 2011 13:28  |
 |
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...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
