I m trying to connect Oracle 11g local instance and running query on base view, however
receiving below error while executing query.
Trace doesn't give me clue where the error is:
Error trace given below:
QUERY: SELECT * FROM employees CONTEXT ('i18n'='us_pst', 'cache_wait_for_load'='true') TRACE
EXECUTION PLAN (
name = Execution
startTime = Thu Jul 7 12:18:22 038 IST 2016
endTime = Thu Jul 7 12:18:22 243 IST 2016
responseTime = -
numRows = 0
state = ERROR
completed = false
waitingTime = 0
STATIC OPTIMIZATION (
staticOptimized = false
staticOptimizationTime = 0
staticOptimizationStart = Thu Jul 7 12:18:22 038 IST 2016
staticOptimizationEnd = Thu Jul 7 12:18:22 038 IST 2016
)
BASE PLAN (
name = employees
database = tutorial
startTime = Thu Jul 7 12:18:22 038 IST 2016
endTime = Thu Jul 7 12:18:22 243 IST 2016
responseTime = -
numRows = 0
state = ERROR
completed = false
fields = [employee_id, commission_pct, salary]
search conditions = []
filter conditions = []
ordered = false
numOfFilteredTuples = 0
numOfDuplicatedTuples = 0
numOfSwappedTuples = 0
swapping = false
memoryLimitReached = false
JDBC WRAPPER (
name = employees
database = tutorial
startTime = Thu Jul 7 12:18:22 038 IST 2016
endTime = Thu Jul 7 12:18:22 243 IST 2016
responseTime = -
numRows = 0
state = ERROR
completed = false
searchConditions = []
orderByFields = []
projectedFields = [employee_id, commission_pct, salary]
additionalSubPlans = 0
additionalErroneousSubPlans = 0
JDBC ROUTE (
name = employees#0
datasource = oracle_source
datasource database = tutorial
startTime = Thu Jul 7 12:18:22 038 IST 2016
endTime = Thu Jul 7 12:18:22 243 IST 2016
responseTime = -
numRows = 0
state = CONNECTION_ERROR
completed = false
exception = Unexpected error creating a connection: Could not create a validated object, cause: ValidateObject failed
SQLSentence =
parameters = []
SQLSentence info =
DBUri = jdbc:oracle:thin:@localhost:1521:ORCL
userName = nbk8hkp
connectionTime = 0
cachedConnection = false
)
)
)
)
Please provide some pointers.
