Home » SQL & PL/SQL » SQL & PL/SQL » INSERT FILES USING DATA TYPE LONG RAW IN ORACLE 7.3
INSERT FILES USING DATA TYPE LONG RAW IN ORACLE 7.3 [message #1760] Mon, 27 May 2002 10:29 Go to next message
Tatiana Morales
Messages: 1
Registered: May 2002
Junior Member
¿How can I insert a file in Oracle 7.3, using a long raw data? because I have the following mistake:
ORA-01438: value larger than specified precision allows for this column
This happens when I want to insert huge files, larger than 100 KB, but when I work with files that have less than 100 KB, I can insert them in the database.
I´m working with ASP.NET

thanks
Re: INSERT FILES USING DATA TYPE LONG RAW IN ORACLE 7.3 [message #1761 is a reply to message #1760] Mon, 27 May 2002 18:21 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am not very sure about this.
I beleive i have read somewhere about the size restriction on long/long raw columns as
pl/sql - 32Kb
sql commands - 64Kb
sqlloader - 64Kb
im also curious!!
If you have a solution/workaround .. pls let me know.

regards

Mahesh Rajendran
Previous Topic: Re: Access to other user's object from procedure
Next Topic: Re: About computation on two columns values
Goto Forum:
  


Current Time: Tue May 21 18:01:32 CDT 2024