users are able to update their own data

According to PeopleBooks.."By default, the Component Processor does not allow an user to make any changes to a record if a record contains an EMPLID key field and its value matches the value of the user's EMPLID" . Function AllowEmplIdChg(true) should be used in order to allow users to update their own data.

SQL PeopleCode requirment for long field

If the long field is not enclosed within %TextIn, then the SQL will work with long field values up to 255 characters long. Anything over that will cause a "Fatal SQL error has occurred" message to pop up - so it's hard to pick up in testing.

INSERT INTO PS_SOME_RECORD(EMPLID
, LONG_FIELD1
, LONG_FIELD2)
VALUES (:1
,%TextIn(:2)
,%TextIn(:3))