Home » Developer & Programmer » Forms » using xmltype and clob in oracle forms 10g (oracle application developer,10g,windows)
using xmltype and clob in oracle forms 10g [message #360931] Mon, 24 November 2008 06:54 Go to next message
galaxy2008
Messages: 2
Registered: November 2008
Junior Member
Hi All,

My form has a grid which has lots of user entered data. i want to send all the data at once to a stored procedure using in xml format (as xmltype).i could not achive it in oracle forms.

the function signature is like this:

CREATE OR REPLACE function "GETCURRDATE"(inp SYS.XMLTYPE)
return int

so i have to:

1.declare a pl/sql variable in oracle forms with type of xmltype.
2. populate the variable.
3. invoke the function (database is oracle 10g).

i have written the following code in in the click event of a pushbutton:

declare 
  var       XMLType; 
  cnt int;
begin 
   var := xmltype('<PERSON> <NAME> ramesh </NAME> </PERSON>');

   cnt:= GETCURRDATE(var);
   message(cnt);
   message(cnt);
	
end;


The form compiles. but whenever i click on the button, the form crashes.FRM-92101 error is displayed (oracle.forms.net.connectionexception: session<11> is aborted).

Same thing happens if i declare and work with a clob variable in oracle forms. Can't we work with xmltype/clob in oracle forms?is these variables/data types only work in sp/function on database server and not in client forms?

i will highly appreciate any help or suggestions. please guide me.thanks in advance.

Arif

[Topic title typo fixed by LF; the original was "oralce forms". Applied [code] tags instead of [color] ones]

[Updated on: Tue, 25 November 2008 00:52] by Moderator

Report message to a moderator

Re: using xmltype and clob in oralce forms 10g [message #361073 is a reply to message #360931] Tue, 25 November 2008 00:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Probably not. Put all your data into a string or long field and pass it to the database and get it to do the work for you.

Remember, Forms is an old product and does not support all the new PL/SQL database types. If you can't see the datatype in the list displayed for 'Data Type' for a form's item then you most probably won't be able to use it in a form.

David
Re: using xmltype and clob in oralce forms 10g [message #361417 is a reply to message #361073] Wed, 26 November 2008 05:52 Go to previous messageGo to next message
galaxy2008
Messages: 2
Registered: November 2008
Junior Member
Hi David,

Thanks a lot. Hopefully oracle will address this issue soon and provide some options to load,parse and manipulate directly in client forms rather than in server.

Cheers!
Re: using xmltype and clob in oralce forms 10g [message #361570 is a reply to message #361417] Thu, 27 November 2008 00:51 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I doubt it.

David
Previous Topic: How to change a color of a button
Next Topic: how to convert oracle table row into txt file
Goto Forum:
  


Current Time: Sat Dec 10 11:14:34 CST 2016

Total time taken to generate the page: 0.11052 seconds