[tanmoy.m]

Hi,

I am trying to call a Stored Procedure from Unix shell script and getting the following error.

254: Too many or too few host variables given.
Error in line 1
Near character position 1

------------------------------------------------------------
My Stored Procedure looks like:

CREATE PROCEDURE SP_PRECAL_ALERT_MESSAGE (
pici_rowcount int
)
RETURNING INT AS pici_rowcount;

------------------------------------------------------------
My shell script looks like:

$INFORMIXDIR/bin/isql -s $DB_INSTANCE <<!EOF
begin work;
execute procedure SP_PRECAL_ALERT_MESSAGE(?);
commit work;
!EOF

------------------------------------------------------------