RE: [sqr-users] insert sql

["Penny Ginn" <pmginn@presby.edu>]

If the Oracle column is defined as "not null," then there's no way you're
going to get a null value in there.

It looks like you're inserting a single space - a non-null column should
allow that as data.

If the column is NOT defined as not null, then you can use the word NULL in
your insert; i.e.
...
     $CLIENTE,
      $FOLIO_FACT,
      #CNT_GRP,
      NULL,
      {FECHA},
...

Mrs. Penny M. Ginn
Associate Director of Information Technology
Presbyterian College
Clinton, SC  29325   864-833-8212

-----Original Message-----
From: sqr-users-bounces+pmginn=presby.edu@sqrug.org
[mailto:sqr-users-bounces+pmginn=presby.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