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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Java + PL/SQL SP + BLOB Parameter

Status
Not open for further replies.
engineer2100

engineer2100

Programmer
Feb 7, 2002
285
US
Greetings All,

I have a JSP that send me a Binary Stream of data to a Oracle 9i Stored Proc. This SP accepts the Binary Stream into a BLOB.

We are facing a problem in that, when we try to call this SP from within JSP for a file with size ~3MB, an exception is raised which is something to do with 'data exceeding max allowed'.

Is there any restriction on having BLOB parameters or is our usage of DBMS_LOB.WRITEAPPEND to write the data, wrong?

Please help!!

Thanks,
Engi
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
860
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
rk68
  • Locked
  • Question
Data fetch issue thru PL/SQL developer
Replies
4
Views
207
rk68
rk68
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
284
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
323
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top