Home » SQL & PL/SQL » SQL & PL/SQL » converting long raw into blob in a procedure over a database-link
converting long raw into blob in a procedure over a database-link [message #206049] Tue, 28 November 2006 07:42
max1005
Messages: 3
Registered: July 2006
Junior Member
Does anyone know how to convert a long raw into a blob in a pl/sql procedure?

The pl/sql procedure is saved in database A. From database A I can select a long raw from database B. But I want to use a pl/sql procedure in database A which gets the long raw from database B. The problems are

- a long raw in a pl/sql procedure can only be 32 KB (in the database it can be 4 GB)
- a blob can not be selected over a database-link

Many thanks,
Max
Previous Topic: executing oracle procedure in visual basic
Next Topic: transferring records
Goto Forum:
  


Current Time: Mon Dec 05 08:31:12 CST 2016

Total time taken to generate the page: 0.09829 seconds