OraFAQ Forum: Forms » dbms_lob usage issue in forms

Home » Developer & Programmer » Forms » dbms_lob usage issue in forms (forms 6i oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_lob usage issue in forms [message #456452]

Tue, 18 May 2010 00:19

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

Report message to a moderator

Re: dbms_lob usage issue in forms [message #456490 is a reply to message #456452]

Tue, 18 May 2010 03:00

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

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

Report message to a moderator

Re: dbms_lob usage issue in forms [message #457094 is a reply to message #456534]

Fri, 21 May 2010 01:02

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

Report message to a moderator

Re: dbms_lob usage issue in forms [message #457161 is a reply to message #457094]

Fri, 21 May 2010 06:59

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

Report message to a moderator

Re: dbms_lob usage issue in forms [message #689314 is a reply to message #457094]

Sun, 19 November 2023 11:43

juanrikrdo
Messages: 1
Registered: October 2007

Junior Member

Dear David,

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

Regards,

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 11:10:29 CST 2024