[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: How to retrieve PeopleCode (long raw data type)?



Thanks for the tips. We are using version 7.5 here. Basically my original
question was how to retrieve Long Raw data. I need to retrieve the
PeopleCode only for particular customized Records. And the requirement is to
retrieve it from the database, instead of using the Application Designer or
other peopletools.

I know the PeopleCode is stored in the peopletools table PSPCMPROG. The data
type of that particular column is LONG RAW. The problem is that whenever I
use select statement to retrieve this column, I get the error message
'inconsistent datatype'. It seems to me that there is no way to retrieve the
long raw data using 'select'.

Any idea, why and how?

Thanks.

- Yuwen