Recent content by Steve

  1. S

    Querying a Table with XMLType

    declare doa_object sys.xmltype; xmldata clob; begin doa_object := :doa_object; xmldata := doa_object.getclobval(); sys.dbms_lob.trim(:xmldata, 0); sys.dbms_lob.append(:xmldata, xmldata); end; This is what the Oracle Monitor runs when the error Occurs, hope this helps
  2. S

    Using TXMLType

    I have written the following code in delphi 6 procedure TForm1.Button1Click(Sender: TObject); var XMLTYPE : TXMLTYPE; begin XMLTYPE := TXMLTYPE.Create(OracleSession1,'steve22'); end; When I run this code I get the following error OCI-21500: internal error code, arguments...
  3. S

    Querying a Table with XMLType

    I have on my machine Windows XP Professional Oracle 10g Release 2 (10.0.2.1), Client And Server DOA - 4.0.7.1 Delphi 6 I have created a table in Oracle called steve_test Name Type Nullable Default Comments ----- ----------- -------- ------- -------- ID1 NUMBER Y BLOB1...
Back
Top