A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
oracle.sql.STRUCT and db user rights
Joined: Jul 09, 2010
Oct 12, 2012 04:26:51
Maybe someone could explain me what action is called in database when in
we are creating new oracle.sql.STRUCT object?
Struct struct = new STRUCT(StructDescriptor.createDescriptor("SCHEMANAME.TEST", dbOracleConnection), dbOracleConnection, myMap);
I needed to check if all required rights are provided to db user.
Thanks a lot in advance.
Joined: Aug 22, 2010
Oct 12, 2012 04:34:09
You need to grant the EXECUTE privilege to users that should be able to use your type.
Edit: see also
I agree. Here's the link:
subject: oracle.sql.STRUCT and db user rights
Need Expert Advice
Reading UDT values using JDBC
Iterating oracle.sql.STRUCT in java
probleme with datasource configuration
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015