| using xmltype and clob in oracle forms 10g [message #360931] |
Mon, 24 November 2008 06:54  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
