Re: Help in SPL reqd
How did you "compile" the stored procedures? If you used isql, try using dbaccess
instead. I've seen simple stored procedures work fine in isql, but any that have return
values usually fail unless I use dbaccess. As for cases 3 and 4 (which look identical),
have you tried specifying a length, i.e. CHAR(14)?
Mark Collins
mcollins@us.dhl.com
The problem lies in how easily and dangerously we forget that
manipulating things is not the same as understanding them.
------------------------
From: "S.Sathish" <ssathish@getafix.cmc.net.in>
Subject: Help in SPL reqd
Date: Mon, 17 Nov 1997 18:40:48 +0500 (GMT+0500)
To: informix-list@rmy.emory.edu
}
} 1) this compiled fine
}
} create procedure temp()
} end procedure
}
} 2) This did not why ?
}
} create procedure proc_tmp ( last char(15),first char(15))
} returning int;
} # ^
} # 201: A syntax error has occurred.
} #
} define x int;
} on exception in (-206)
} create table proc_tab (lname char(15),fname char(15),tele char(15));
}
} insert into proc_tab values (last,first,'1000');
}
} end exception with resume
}
} end procedure
}
} 3)this did not.why?
}
} create procedure temp()
} define x char;
} # ^
} # 201: A syntax error has occurred.
} #
} end procedure;
}
} 4)even this did not.why?
}
} create procedure temp()
} define x char;
} # ^
} # 201: A syntax error has occurred.
} #
} end procedure
}
}
} Informix ODS 7.1 on SCO.
}
} Bye
}
} ******************************************************************************
} S.Sathish
} email :ssathish@cmcbang.ernet.in
} ******************************************************************************
}
}
---------------End of Original Message-----------------