I like to have a procedure to create synonym for xml dynamically. I searched the forum and got the syntax for sql. I didn't find any documentation for this also. What is the syntax to create synonym for xml in a procedure? Please help me.
Thank you, Devi CThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.4,7.6.9 OS: Windows XP HTML,EXCEL,PDF
April 12, 2011, 04:50 PM
Clif
It's easiest to do this from the Data Management Console or the Web Console because there are many options.
Here's a simple example using sample schema dmxord.xsd that describes dmxord.xml, both located in the ibisamp directory, creating a synonym there.
CREATE SYNONYM ibisamp/dmxord FOR dmxord.xsd DATABASE ibisamp/dmxord.xml DBMS XML AT ibisamp