Forum Stats

  • 3,817,476 Users
  • 2,259,340 Discussions
  • 7,893,791 Comments

Discussions

Inserting data in oracle database using ASP.

773278
773278 Member Posts: 588 Green Ribbon
hi all.

i am using oracle database 11g R2,windows xp,ASP.
i am able to store texts and numbers but i am not able to store image in blob.
here is my table structure.
Roll number
Name varchar2(20)
Subject varchar2(20)
Marks number
Attach Blob
my problem is in blob i am not able to insert image into database using ASP codes.
here is the code.
<%
Dim conn,recset 



set conn=server.CreateObject("ADODB.connection")
set recset=server.CreateObject("ADODB.recordset")
'set conn=Server.CreateObject("ADODB.Connection")
 conn.Provider="MSDAORA;Data Source=orcl;User ID=XXXX;Password=XXX"


conn.Open(conn) 

Dim r,n,s,m,att

r=upload.Form("roll")
n=upload.Form("nam")
s=upload.Form("sub")
m=upload.Form("mark")
att=upload.Form("FILE1")

Response.Write "Succssfully Inserted"
conn.execute "insert into table1 values('"&r&"','"&n&"','"&s&"','"&m&"','"&file1&"')"
conn.close

%>
plz guide me and help me out.

thanks in advance..
This discussion has been closed.