Need help in Report.... Conversion of data elements

Former Member — Mon, 23 Jul 2007 04:10:43 GMT

Hi All,

Iam doing a report. Chk the code below

SELECT roleid

FROM SRRELROLES

INTO gs_roleid

WHERE objkey = gs_guid

AND objtype = ‘BUS2010020’.

When i activate this it is throwin an error sayin dat <b>" GS_GUID and OBJKEY is not mutually convertible in a unicode program.... "</b>

<b>Here objkey is RAW 16 and gs_guid is char(70)..</b>

Can anybody help me out in this... and is there any conversion routines for doing this.

Thanks,

Shiva shekar k

Re: Need help in Report.... Conversion of data elements

Former Member — Mon, 23 Jul 2007 04:15:56 GMT

declare a gs_guid variable as raw data type .. and then convert it to char

and for conversion refer