Oracle 9.2 + Delphi 5 + CLOB/XMLTYPE in a function result

[excnea]

Hello

Im using your trial version of ODAC to test an applications's compatibility with my database. But i have some things that i want to ask..

How can i get XML-data trought a stored procedure (or CLOB data maybe)?

When i trying to make this:

Code: Select all

procedure TForm1.Button1Click(Sender: TObject);
begin
  with TOraStoredProc.Create(nil) do
  begin
    Session := OraSession1;
    StoredProcName := 'MySchema.Test.Test';
    ExecProc; // ').GetClobVal();
END;

END;

When i trying to change result type of my function to XMLTYPE i get "Access violation" error on ExecProc...

So can somebody explain me what i need to do to get a XML from a database throught my stored function??? (without making any serious changes to my database objects)

Thank you.

(im using Delphi 5, Oracle Client 8, Oracle Server 9.2, Windows XP SP3)

[excnea]

hello?

[Plash]

Try to use the same version of Oracle client as the server version - 9.2.