Hey!
I recommend that you *do not* use PL-SQL. Oracle themselves have
dropped this in favor of Java. PL-SQL was proprietary to Oracle.
One credit to Oracle is they are learning the lesson that Microsoft
still has not learned.
Instead do something like this:
try {
PreparedStatement pstmt = con.prepareStatement("INSERT INTO yourTable
(name, screenshot) " +
"VALUES (?, ?)");
// provide values for prepared statement and execute update
pstmt.setString (1, theName);
// pump it in with a file input stream
pstmt.setBinaryStream (2, fis, maxFileSize);
pstmt.executeUpdate();
pstmt.close();
} catch (Exception e) { e.printStackTrace(); }
Isn't Java kewl.
Sorry about the response to this off-topic posting, but when Grant
gave the wrong reply, I just had to make things right.
Sans adieu,
Danny Rubis
Grant Cullen wrote:
> Check out site http://www.rocket99.com/oracle/
>
> under link PL-SQL there is sample code for dealing with blobs.
>
> Grant Cullen
> UNIX System Admin
> [EMAIL PROTECTED]
> 416-935-6558
>
> -----Original Message-----
> From: Suon, Thla [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 10, 2000 13:42
> To: [EMAIL PROTECTED]
> Subject: How Do I Insert Informations into a BLOB datatype
> Column...Please Help.
>
> Hello Everyone,
>
> Can you please help me out there? I am having problem of how to insert a
> large volume of
> Informations, whether it be asciis, screenshots, images into a table that is
> of BLOB
> datatype. If anyone has code samples of ideas of how to implement this,
> please
> let me know. I would greatly appreciate your help.
>
> Thank you,
> Thla ("Tyla")
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
