Hi ,

I have code like below in my ksh script, but getting an error as SP2-0253: data item 1 ("SAMPLE_ID") will not fit on line , pls help me. thanks.


if (( CHECKS == 0 )) || (( CHECKS == 1 ))

then

V_SAMPLE_ID=$( $ORACLE_HOME/bin/sqlplus -S / <<EOF
whenever sqlerror exit 1 rollback;
whenever oserror exit 1 rollback;

--Set up pagesize parameters.
set newpage 0;
set space 0;
set echo off;
set pagesize 0;
set heading off;
set verify off;
set feedback off;
set trimspool off;
set termout on;
set colsep "";
set linesize 5;

select SAMPLE_ID from sample_m
where NAME=$MFGLBL and TVALUE=$C_SAMPLE;
exit;
EOF
)
v_count=$?
print "V_SAMPLE_ID: $V_SAMPLE_ID" >> $LOG_FILE


fi

right now i'm able to get the value after adding a substr in the select statement, but the value is getting '2003 15588' , instead of '20031558'

thanks

any solution for this problem

It's against the:

Simple rules of the UNIX.COM forums:

to bump up questions!

My crystal ball is fuzzy, but I think you're assuming we know your DB schema.....

realy sorry about that.