Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL to insert XML as BLOB in Oracle database
- Thread starter cmehend
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
The BLOB data type on Oracle accepts standard text.
Your problem will be that there are no variables in SQL Server that allow more than 8000 characters at a time.
You may want to do a direct insert into select from statement to get the data from your SQL Server to your Oracle server.
Denny
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(My very old site)
Your problem will be that there are no variables in SQL Server that allow more than 8000 characters at a time.
You may want to do a direct insert into select from statement to get the data from your SQL Server to your Oracle server.
Denny
--Anything is possible. All it takes is a little research. (Me)
(My very old site)
- Status