Re: OCIAttrGet returns wrong value for schemaName

From: Philip S Zhan <szhan_at_calum.csclub.uwaterloo.ca>
Date: 22 Jan 2000 23:28:01 GMT
Message-ID: <86dee1$poe$1@watserv3.uwaterloo.ca>

Thank you for your followup. I will check the value Monday.

Philip

In article <38883A3D.E3CF9FCC_at_nowhere.edu>, Markus <nobody_at_nowhere.edu> wrote:
>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 Sat Jan 22 2000 - 17:28:01 CST