Insert field type RAW

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 200.246.44.132] 'Marcelo Santos Bueno' on September 06, 2001 at 10:09:36 EST:

Hello!

What is wrong below. The field VARDATA (KAPOL TABLE POOL) is RAW type, and every time return sy-subrc = 4. How can I insert RAW field R/3 using native ORALCE-SQL.

EXEC sql.
INSERT INTO za017_msb

(kappl, lifnr, matnr, ekorg, werks, esokz, datbi, vardata)

(SELECT distinct substr(varkey,4,2),
substr(varkey,9,10),
substr(varkey,19,18),
substr(varkey,37,4),
substr(varkey,42,4),
substr(varkey,46,1),
substr(varkey,47,8),
vardata
from kapol where tabname = 'A017')
ENDEXEC.

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hello! : What is wrong below. The field VARDATA (KAPOL TABLE POOL) is RAW type, and every time return sy-subrc = 4. How can I insert RAW field R/3 using native ORALCE-SQL. : EXEC sql. : INSERT INTO za017_msb : (kappl, lifnr, matnr, ekorg, werks, esokz, datbi, vardata) : (SELECT distinct substr(varkey,4,2), : substr(varkey,9,10), : substr(varkey,19,18), : substr(varkey,37,4), : substr(varkey,42,4), : substr(varkey,46,1), : substr(varkey,47,8), : vardata : from kapol where tabname = 'A017') : ENDEXEC.