| BLOB upload image [message #370125] |
Tue, 19 December 2000 06:04 |
think
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
hi,
i'm a newbie in pl/sql,but now i'm trying to upload image from a webserver to my oracle8i database using BLOB. i 'think' i've create the table with correct datatype(ordsys.ordImage), initiate the column using empty_blob(),the URL and the filename. so far i didnt recieve any message....
but the following statement give me an error
obj1.import(abc);
update imgtable set image = obj1 where id=1;
where obj1 ORDSYS.ORDIMAGE;
abc RAW(2000) := NULL;
may i know where have i done wrong....
or do anyone got a working sample for me to learn??
thanks alot
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
