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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LOBs

Status
Not open for further replies.
IMAUser

IMAUser

Technical User
May 28, 2003
121
CH
Hi ,
Never used BLOBs before, so a few questions.

1.I need to create a csv report and store it in the BLOB column of a table. The report will not be stored on the file system at all. How do I do this, I tried a siple eg trying to insert values in the column and it didnt work.
Came back with an Error ORA-01465 Invalid hex number, which didnt make sense at all, because I wasnt doing anything with the ROWIDs.

2. Once I have managed to store the data on the column, how do I retrieve it.

3. While storing the rep, will it store one huge report row by row or wil I have to include a NEWLINE character after each row of one report.

I did read about DBMS_LOB, but it dosent make much sense. Perhaps a working example will be a better source to understand.

Any help appreciated.

 
Sort by date Sort by votes
What tool do you use? Is it Forms (as this is Developer forum)? If so, how do you obtain this BLOB?

Regards, Dima
 
Upvote 0 Downvote
Apologies, didnt realise was posting it in FORMS forumn. The only tool I can use is PL/SQL.

Well, I do not have a BLOB. I need to createa CSV file and store it in the BLOB column. Also, I cannot write the file to a file system. So I am assuming there is a way I can keep writing the data , one record in every loop, to a local BLOB variable within my PL/SQL package. This variable can then be inserted in my table which alredy has a BLOB column.

Now thats what I m planning to do. Dont know if its possible.

Thnx
 
Upvote 0 Downvote
I can't understand why DBMS_LOB doesn't suit your needs. Did you try WRITE/WRITEAPPEND procedures?

Regards, Dima
 
Upvote 0 Downvote
Thanks Dima,
But I have only read about DBMS_LOB and didnt understand it. So was wondering if there was a working example anywhere which I could look at.
 
Upvote 0 Downvote
I suppose Oracle manuals (tahiti.oracle.com) may help you.

Regards, Dima
 
Upvote 0 Downvote

Phew !!
Managed to store the rep as a LOB onto a table.
The next task is sending this LOB as an attachement to a set of users via mail.

Can clues if this is possible or u aware of anywhere I can look at such info. Also, fo you think there is a Mail functionality provided by Oracle.

TIA
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top