Home » Developer & Programmer » Data Integration » Warehouse Builder deployment problems...
Warehouse Builder deployment problems... [message #92842] Wed, 10 October 2001 23:16 Go to next message
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 Go to previous message
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...

----------------------------------------------------------------------
Previous Topic: Re: data ware housing
Next Topic: Re: Connection problem with SQL database to C++
Goto Forum:
  


Current Time: Thu Mar 28 14:51:24 CDT 2024