2007 Jul 23 7:54 AM
Hi,
In table crmd_order_index <b>there is a field GUID of data type CRMD_OBJECT_GUID and domain SYSUUID which is RAW 16.</b>
<b>and in the another table a thr is a field OBJKEY of data type char 70.</b>
When i execute the code
<b>SELECT guid
FROM CGPL_PROJECT
INTO gs_guid
WHERE external_id = p_caid.</b>
**get the ROLEID with respect to the object key and type BUS2010020
<b>SELECT roleid
FROM SRRELROLES
INTO gs_roleid
WHERE objkey = gs_guid
AND objtype = BUS2010020.</b>
When i
avtivate it is it is throwin an error sayin dat
"<b> GS_GUID and OBJKEY is not mutually convertible in a unicode program.... "
and the guid is coming from CGPL_PROJECT.</b>
Please Could anybody reply me ASAP.
regards,
Shiva shekar k
Hi,
In table crmd_order_index <b>there is a field GUID of data type CRMD_OBJECT_GUID and domain SYSUUID which is RAW 16.</b>
<b>and in the another table a thr is a field OBJKEY of data type char 70.</b>
When i execute the code
<b>SELECT guid
FROM CGPL_PROJECT
INTO gs_guid
WHERE external_id = p_caid.</b>
**get the ROLEID with respect to the object key and type BUS2010020
<b>SELECT roleid
FROM SRRELROLES
INTO gs_roleid
WHERE objkey = gs_guid
AND objtype = BUS2010020.</b>
When i
avtivate it is it is throwin an error sayin dat
"<b> GS_GUID and OBJKEY is not mutually convertible in a unicode program.... "
and the guid is coming from CGPL_PROJECT.</b>
Please Could anybody reply me ASAP.
regards,
Shiva shekar k
2007 Jul 23 8:01 AM
Change the code like this
SELECT guid
FROM CGPL_PROJECT
INTO gs_guid
WHERE external_id = p_caid.
data objkey type SRRELROLES-objkey.
objkey = gs_guid.
SELECT roleid
FROM SRRELROLES
INTO gs_roleid
WHERE objkey = objkey
AND objtype = BUS2010020.
Reward points if useful
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |