Home » Developer & Programmer » Forms » dbms_lob usage issue in forms (forms 6i oracle 10g)
dbms_lob usage issue in forms [message #456452] Tue, 18 May 2010 00:19 Go to next message
didiera
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member
Hello everyone,

I am trying to use clob variable in a forms to dynamically create a flat file fed-in by some query results. The program is quite simple but it crashes right at clob variable initialisation. The oracle account I use to develop and test seems ok since it's default tablespace is TEMP and this account has DBA privilege on the database. However as soon as I issue the dbms_lob.createtemporary(my_clob,TRUE,10) the form crashes - it just exists.

In your opinion what could be the issue? I have also tried the dbms_lob.open() flavor but this time I'm getting an ORA-06502 (anyway my point is not to use a persistent clob variable)


thanks for suggesting clues.
Didier
Re: dbms_lob usage issue in forms [message #456490 is a reply to message #456452] Tue, 18 May 2010 03:00 Go to previous messageGo to next message
didiera
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member
Ok I'm talking to myself now. In fact I think that this processing is meant to be carried-out server-side right? I think that's the clue. I'll ry it and update this post if it works. That doesn't mean u can't bring-in your opinion on the question.

thanks,
Didier

[Updated on: Tue, 18 May 2010 03:01]

Report message to a moderator

Re: dbms_lob usage issue in forms [message #456534 is a reply to message #456490] Tue, 18 May 2010 06:06 Go to previous messageGo to next message
didiera
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member
I have completed that part and as far as my form procedure call is concerned, it's working...now I only need to know how to retrieve the clob and download
it as a file client-side. Has any of you guys done that before?

thanks in advance.
Didier
Re: dbms_lob usage issue in forms [message #457094 is a reply to message #456534] Fri, 21 May 2010 01:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at these or search this forum for 'clob', 'blob, and 'lob'.

Displaying Images
"Displaying Image in Forms 6i from BLOB Database field"
http://www.orafaq.com/forum/t/51889/67467/

"Displaying Image in Report 6i from named file"
http://www.orafaq.com/forum/m/157010/67467/#msg_157010

About loading and displaying images files
http://cs-netlab-01.lynchburg.edu/courses/Oracle/PPTSlides/08ch.ppt
Save Images in Database From Forms - Download it Here
http://www.orafaq.com/forum/t/60477/67467/
Also
http://www.orafaq.com/forum/m/163347/67693/#msg_163347
How to store image in BLOB and display in oracle forms
http://www.orafaq.com/forum/t/95015/67467/
Capture image through webcam
http://www.orafaq.com/forum/t/89431/67467/

David
Re: dbms_lob usage issue in forms [message #457161 is a reply to message #457094] Fri, 21 May 2010 06:59 Go to previous messageGo to next message
didiera
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member
Hi,

thx a lot that makes a good heap of reading for the week-end.

cheers,
Didier
Re: dbms_lob usage issue in forms [message #689314 is a reply to message #457094] Sun, 19 November 2023 11:43 Go to previous message
juanrikrdo
Messages: 1
Registered: October 2007
Junior Member
Dear David,

What about showing clob (text plain column) using forms 6i?

Regards,
Previous Topic: biomatric
Next Topic: forms-40010 cannot read form Z:\ORAFMX\GENLOGIN.fmx
Goto Forum:
  


Current Time: Thu Feb 22 04:32:00 CST 2024