Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Need help in Conversion routines

Former Member
0 Likes
361

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

1 REPLY 1
Read only

Former Member
0 Likes
332

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