[sqr-users] insert sql

[Eduardo_Bugarin@hdm.honda.com]

hello everyone

I need to insert data by sql, but I have the next message

ORA-00984: COLUMN NOT ALLOWED HERE

I know that this is about the fields on the Oracle table

could some one tellme if this is correct:

begin-procedure INSERT_DAT
begin-sql
  insert into SOME_TABLE values (
      {ARHDM},
      $GROUP_ID,
      {ARHDM},
      $CLIENTE,
      $FOLIO_FACT,
      #CNT_GRP,
      ' ',        IN THIS FIELD I NEED TO INSERT AN EMPTY DATA, BUT THE
FIELD DOSEN´T ACCEPT NULLS
                  HOW CAN I INSERT ????????????????????
      {FECHA},
      {CERO_CD},
      ' '
end-sql
end-procedure


thank you for your help






_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users