While I seem to be quite capable of using this command from the SQL*Plus window, I am unable to get to to work when I try and get it to work through access to my oracle DB.
Table:
ID - number, unique
Name - string
mydate - date
myxml - xmltype
The error message I am getting is "Undefined function 'sys.XMLType.createXML' in expression.". I assume that this is because Access is trying to process my insert command, rather than passing it back to Oracle for processing via the ODBC link. What is my easiest way to get data into my oracle DB, when I have XML that I want to store in an XMLType. Do I need to use some for of stored procedure? (I have used these in SQL Server, but not in Oracle yet - only been using it for a day or two).
Cheers,
Matt
Table:
ID - number, unique
Name - string
mydate - date
myxml - xmltype
The error message I am getting is "Undefined function 'sys.XMLType.createXML' in expression.". I assume that this is because Access is trying to process my insert command, rather than passing it back to Oracle for processing via the ODBC link. What is my easiest way to get data into my oracle DB, when I have XML that I want to store in an XMLType. Do I need to use some for of stored procedure? (I have used these in SQL Server, but not in Oracle yet - only been using it for a day or two).
Cheers,
Matt