| Warehouse Builder deployment problems... [message #92842] |
Wed, 10 October 2001 23:16  |
prakash
Messages: 24
Registered: October 2001
|
Junior Member |
|
|
I am unable to execute a simple mapping(no transformations applied) to transfer data from one Oracle DB(OLTP) into another Oracle DB(warehouse).When I attempt to deploy my PLS scrip that executes the mapping,I get an error "PLS-00454 with a returning into clause,the table expression canot be remote or a sub query".Any help in resolving this would be greately appreciated.
----------------------------------------------------------------------
|
|
|
|
| Re: Warehouse Builder deployment problems... [message #92878 is a reply to message #92842] |
Thu, 13 December 2001 07:10  |
Tin Pham
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
Prakash,
If you use a db link with a returning into clause, you will get this error. I get the same error when I tried to update a table through db link and used the returning to assigned the value into a local variable. I hope this helps...
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
