RE: [sqr-users] insert sql

["Aguirre, Jose" <JAguir@lsuhsc.edu>]

Use this function for all the not nullable fields before your insert:

  LET $FIELD_NAME = NVL($FIELD_NAME, ' ') 


Good luck,

José A. Aguirre

-----Original Message-----
From: sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org
[mailto:sqr-users-bounces+jaguir=lsuhsc.edu@sqrug.org] On Behalf Of
Eduardo_Bugarin@hdm.honda.com
Sent: Tuesday, October 05, 2004 2:45 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] insert sql

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

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