I would like to create a stored procedure that takes the name of a table and can be a line_ID and serialized in an XML string .
The table may contain clubbs and blobs.
Can I do it in PL / SQL or do I have to use Java?
It has a table with all the updates and explores some tables, X-X versions or X-day data (something like chg_date (default: sysdate) in the table, Chg_type (U or D) , chg_xml , and maybe some metadata about the user). Possible use: - It can also keep all the data and can be used as logs - the ability to return the line to any previous value. - Ability to EDI in a specific format.
I do not want to use Oracle's flash back query because there is no guarantee of availability of data.
In Oracle, there is a function to return a query in XML format.
In this example, replace your table name and table, and with queued & amp; Rowid I tested it and it starts working with clubbs and blops, it gives data in hex for blobs. Double
SELECT DBMS_XMLGEN.getxmltype (Select from & amp; table_name where rowid = '' & amp; rowid '' ' / Html>
Comments
Post a Comment