Correction: OCIAttrGet returns wrong value for schemaName

From: Philip S Zhan <szhan_at_calum.csclub.uwaterloo.ca>
Date: 20 Jan 2000 20:36:25 GMT
Message-ID: <867rk9$igl$1@watserv3.uwaterloo.ca>

The corrected statement:

I have a schema name "XXX" and an OSP name "YYY" under that schema. The OSP is published as a PUBLIC SYNONYM. My application accesses that OSP as a PUBLIC SYNONYM the from schema "ZZZ". In the following OCI call, it suppose to return schemaName value "XXX". But returns "XXXYYY" for the schemaName instead of "XXX". Another call to get the OSP name is OK (i.e., "YYY"). So the full OSP access becomes XXXYYY.YYY instead of XXX.YYY. OCIAttrGet((dvoid*) parmh,

(ub4)OCI_DTYPE_PARAM,
(dvoid*) &schemaName,
(ub4*) &schemaNameLength,
(ub4)OCI_ATTR_SCHEMA_NAME,
systemHandle->errorHandle());

OCI library 8.0.5 (checked the version in libclntsh.so.1.0).

Why?

Please reply to pszhan_at_yahoo.com. Thanks.

Philip Received on Thu Jan 20 2000 - 14:36:25 CST