Re: OCIAttrGet returns wrong value for schemaName

check the value of your out arg "schemaNameLength". I would be supprised if it's not 3.

(oracle dosn't NUL term the out strings!)

markus

Philip S Zhan wrote:
>
> I have a schema name "XXX" and an OSP name "YYY" under that schema. 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 Fri Jan 21 2000 - 04:51:41 CST