Oracle 9.2 + Delphi 5 + CLOB/XMLTYPE in a function result
Posted: Thu 12 Nov 2009 13:01
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:
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)
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)