We actually did this by modifying DOA-there's a parameter to oci login that controls the login type. We added an enumerated type to control the login type and added it to tOracleSession.
Is there a way to log on as sysdba? The Oracle Enterprise tools do this, and I'd like to as well.
Also, for some functions when the o7_dictionary_accessibility parameter is false you need to be logged in as sysdba to do things like grant select to sys schema tables. Any thoughts?
TIA!
I'm having trouble getting arrays to insert properly-standard fields work OK, but a long field gives wierd stuff.
I think I'm doing everything properly...
Let me know.
TIA, Eric Allen
Here's an example of what I'm doing:
const
nArraySize = 100 ;
var
asText : variant ;
oqryScript...