Home » Developer & Programmer » Forms » built-in package (dbms_xmlgen) (merged 5)
built-in package (dbms_xmlgen) (merged 5) [message #417778] Tue, 11 August 2009 09:22 Go to next message
programmer73
Messages: 6
Registered: February 2008
Location: iraq
Junior Member

Hi everybody
if you can help me,plz do .....
I'm using oracle DB 9i with developer10g , i need to attach the DB built-in package (dbms_xmlgen) to the forms so i can use this code ..........
SET SERVEROUTPUT ON
DECLARE
ctx dbms_xmlgen.ctxhandle;
xml clob;
xmls varchar2(4000);
begin
ctx:=dbms_xmlgen.newContext('select * from TEMP');
DBMS_XMLGen.setRowsetTag(Ctx, 'A');
DBMS_XMLGen.setRowTag(Ctx, 'B');
xml:= DBMS_XMLGEN.getXML(Ctx);
xmls:= dbms_lob.substr(xml,32767,22);
insert into t1 values (xmls);
dbMS_OUTPUT.PUT_LINE(xmls);
commit;
end;

Thank you
Re: built-in package (dbms_xmlgen) [message #417782 is a reply to message #417778] Tue, 11 August 2009 09:28 Go to previous message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
1) Can you please use code tags when posting code - have a look at the orafaq forum guide if you don't know how.

2) You don't attach db packages to forms, there is no such concept. You can attach forms packages (pll's) to forms.

3) You need to create a public synonym for the package in the db if there isn't one already and grant execute permission on it to your user.
Previous Topic: SET_FORM_PEOPERTY
Next Topic: frm-40509: unable to update record
Goto Forum:
  


Current Time: Wed Dec 07 12:39:16 CST 2016

Total time taken to generate the page: 0.05428 seconds