Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Setting ROLE in Oracle
Setting ROLE in Oracle
Posted: 2003/07/08 17:20
 
I'm trying to set a role in Oracle 9 to obtain permissions to view certain tables.

Everything works fine in SQLPlus but when I use the OCIQuery.SQL to execute the same ROLE statement, "noe127/ds Cannot call Open for a statement without a rowset".
RE: Setting ROLE in Oracle
Posted: 2003/07/09 09:40
 
Hello !

Instead of OCIQuery.Open use OCIQuery.ExecSQL.

Regards,
Dmitry