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: problems with script
Next Topic: if you Please
Goto Forum:
  


Current Time: Sat Aug 19 13:40:36 CDT 2017

Total time taken to generate the page: 0.04198 seconds