RE: [sqr-users] insert sql

[kevin.reschenberg@sparkpath.com]

It looks like you are asking about two problems--the null column and the
error message.  I have a suggestion for the error.

Check to be sure that the contents of your substitution variables, such
as {ARHDM}, contain quotes if necessary.  A value without quotes may
look like a column name to Oracle.  The following example will get the
"column not allowed here" error because the second value is not
enclosed in quotes:

insert into ps_animal_tbl values('CAT',Cat,'Cat') 

If we use a substitution variable:

insert into ps_animal_tbl values('CAT',{Cat},'Cat')

it will work as long as {Cat} is defined to include quotes:

#define Cat  'Cat' 

You could also get around the error by simply enclosing the entire
substitution variable in quotes:

'{ARHDM}'


Kevin Reschenberg
SparkPath Technologies, Inc.
(949) 466-1674

www.sparkpath.com

 
-------- Original Message --------
Subject: [sqr-users] insert sql
From: Eduardo_Bugarin@hdm.honda.com
Date: Tue, October 05, 2004 12:44 pm
To: sqr-users@sqrug.org

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