Recent content by David Best

Delphi 6, Win2k server, Oracle 9.2, DOA 4.0.3 and DOA 4.0.6 I'm getting a Privileged instruction exception from ExtProcShare -> SetExternalSVC -> LogOn at the line OCICall(OCIHandleAlloc(envhp, errhp, OCI_HTYPE_ERROR, 0, nil)); This is long-time working code. The only change around the time...

The external stored procedure is written in Delphi using DOA and is called from pl/sql.

We have DOA 4.0.3 Is there a way to return a cursor from an external stored procedure? TIA

I'm using Oracle 9.2.0.1 on W2K Server and find that the systimestamp function only has 1/100 second precision and I haven't found any setting that will increase it. So I thought to use this as an experiment with writing extended stored procedures....bad choice it seems :) The use is as the...

I will be limiting this to simple functions with elementary data types, so querying USER_ARGUMENTS might just do the trick. Thanks!

How can I return an OCIDATETIME value from an external stored proc function?

That's disappointing. I have a helper library which works with queries and stored procs in a generic way. I am trying to implement a generic 'CallFunction' which returns the result as a variant. I suppose I can query the system tables for the info, but I expected DOA to do it for me.

Using TOracleQuery.Describe for a stored proc seems to do nothing. Query.Sql.Text := ':Result := MyProc(:arg1);'; Query.Describe; Both FieldCount and VariableCount are 0. How do I get the parameter descriptions? I must be missing something obvious! Thanks