RE: Unable to create Stored Procedure

Posted in 1999

Barnes, Steve (IFMG) — Fri, 7 May 1999 15:54:20 -0400 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BE98C3.65D0EA2C Content-Type: text/plain; charset="iso-8859-1" The syntax error positioning for stored procedures seems to be vague at the best of times, something this early on could be caused by a missing 'END PROCEDURE;'? HTH. -----Original Message----- From: glynb@bicceri.demon.co.uk [mailto:glynb@bicceri.demon.co.uk] Sent: Friday, May 07, 1999 11:57 AM To: informix-list@iiug.org Subject: Unable to create Stored Procedure I am having problems attempting to create a Stored Procedure using dbaccess. When running the SQL I am getting a Syntax Error highlighting the word "procedure" as follows :- create procedure pr_ins_begrn(grn char(10),lui char(10)) ^ (SYNTAX ERROR SHOWN HERE) define P_insppc float; define P_insppc2 float; select pulin_insppc into P_insppc from pulin, pugrn where pugrn_grn = grn and pugrn_orderno = pulin_orderno and pugrn_ordline = pulin_ordline; (SNIPPED) I am the owner of the database in question and I have DBA privileges. Can anyone out there shed some light ?? TIA Glyn Balmer Informix-OnLine 7.13 HPUX 10.0 -- "Nothing succeeds like a toothless budgerigar" -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own ------_=_NextPart_001_01BE98C3.65D0EA2C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Unable to create Stored Procedure</TITLE> </HEAD> <BODY> The syntax error positioning for = stored procedures seems to be vague at the best of times, something = this early on could be caused by a missing 'END PROCEDURE;'? HTH. <UL><UL> <A NAME=3D"_MailData">-----Original = Message-----</A> From:   = glynb@bicceri.demon.co.uk [<A = HREF=3D"mailto:glynb@bicceri.demon.co.uk">mailto:glynb@bicceri.demon.co.= uk</A>] Sent:   Friday, May 07, 1999 11:57 AM To:     informix-list@iiug.org Subject:       = Unable to create Stored = Procedure  I am having problems attempting = to create a Stored Procedure using dbaccess. When running the SQL I am getting a = Syntax Error highlighting the word "procedure" as follows = :- create procedure pr_ins_begrn(grn = char(10),lui char(10))        = ^ (SYNTAX ERROR SHOWN HERE) define P_insppc float; define P_insppc2 float; select pulin_insppc into = P_insppc from pulin, pugrn where pugrn_grn =3D grn   and pugrn_orderno =3D = pulin_orderno   and pugrn_ordline =3D = pulin_ordline; (SNIPPED) I am the owner of the database in = question and I have DBA privileges. Can anyone out there shed some light = ?? TIA Glyn Balmer Informix-OnLine 7.13 HPUX 10.0 -- "Nothing succeeds like a = toothless budgerigar" -----------=3D=3D Posted via Deja = News, The Discussion Network =3D=3D---------- <A HREF=3D"http://www.dejanews.com/"; = TARGET=3D"_blank">http://www.dejanews.com/</A>    &n= bsp;  Search, Read, Discuss, or Start Your = Own   =20 </UL></UL> </BODY> </HTML> ------_=_NextPart_001_01BE98C3.65D0EA2C--

RE: Unable to create Stored Procedure

Related threads

Your privacy choices