OraFAQ Forum: Forms » built-in package (dbms

Home » Developer & Programmer » Forms » built-in package (dbms_xmlgen) (merged 5)

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

built-in package (dbms_xmlgen) (merged 5) [message #417778]

Tue, 11 August 2009 09:22

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

Report message to a moderator

Re: built-in package (dbms_xmlgen) [message #417782 is a reply to message #417778]

Tue, 11 August 2009 09:28

cookiemonster
Messages: 13938
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.

Report message to a moderator

Previous Topic:	SET_FORM_PEOPERTY
Next Topic:	frm-40509: unable to update record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:24:08 CDT 2024