Re: Help in SPL reqd
You may think this is strange but you probably get this error due to a
lack of a semi-colon on hte end procedure line. Dont believe me? Try
it!
Jason
On 17 Nov 1997 08:53:31 -0500, ssathish@getafix.cmc.net.in
("S.Sathish") wrote:
>
>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
>******************************************************************************
>
>
Jason Harris
Informix DBA
Westpac Banking Corporation
NOTE: I add all these address at the bottom of people who spam me
Now when their extractors extract my e-mail address they will also
end up spamming each other.
root@localhost
postmaster@localhost
wtcjr@ix.netcom.com
Shevsky@hotmail.com
speech@speechrecognition.com
SmartBiz@NevWest.com
slender@juice4u.net
sbliss@earthfriends.com
ron@moneyaction.com
removeme@gwh.net
rocco@lostvegas.com
market@DRAWBRIDGE.NET
Foxyrusski@mail-response.com
emaster@email-man.com
waynesmail@earthlink.net
FreeWay5@dm1.com
new.zealand@xtra.co.nz
sports@compuserve.com
18626588@10354.com
56372125@15132.com
infinity@savoynet.com
info@webavenues.com