RE: Unable to create Stored Procedure
Posted in 1999
Topics: Stored Procedures & SPL, Server Administration
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>
<P><FONT SIZE=3D2 FACE=3D"Arial">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;'?</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">HTH.</FONT>
</P>
<UL><UL>
<P><A NAME=3D"_MailData"><FONT SIZE=3D2 FACE=3D"Arial">-----Original =
Message-----</FONT></A>
<BR><B><FONT SIZE=3D2 FACE=3D"Arial">From: =
glynb@bicceri.demon.co.uk [<A =
HREF=3D"mailto:glynb@bicceri.demon.co.uk">mailto:glynb@bicceri.demon.co.=
uk</A>]</FONT></B>
<BR><B><FONT SIZE=3D2 FACE=3D"Arial">Sent: </FONT></B> <FONT =
SIZE=3D2 FACE=3D"Arial">Friday, May 07, 1999 11:57 AM</FONT>
<BR><B><FONT SIZE=3D2 =
FACE=3D"Arial">To: </FONT></B> <FONT SIZE=3D2 =
FACE=3D"Arial">informix-list@iiug.org</FONT>
<BR><B><FONT SIZE=3D2 =
FACE=3D"Arial">Subject: </FONT>=
</B> <FONT SIZE=3D2 FACE=3D"Arial">Unable to create Stored =
Procedure</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial"> I am having problems attempting =
to create a Stored Procedure using dbaccess.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">When running the SQL I am getting a =
Syntax Error highlighting the word</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">"procedure" as follows =
:-</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">create procedure pr_ins_begrn(grn =
char(10),lui char(10))</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> =
^ (SYNTAX ERROR SHOWN HERE)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">define P_insppc float;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">define P_insppc2 float;</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">select pulin_insppc into =
P_insppc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">from pulin, pugrn</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">where pugrn_grn =3D grn</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> and pugrn_orderno =3D =
pulin_orderno</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> and pugrn_ordline =3D =
pulin_ordline;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(SNIPPED)</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I am the owner of the database in =
question and I have DBA privileges. Can</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">anyone out there shed some light =
??</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">TIA</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Glyn Balmer</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Informix-OnLine 7.13</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">HPUX 10.0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">--</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">"Nothing succeeds like a =
toothless budgerigar"</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">-----------=3D=3D Posted via Deja =
News, The Discussion Network =3D=3D----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"><A HREF=3D"http://www.dejanews.com/" =
TARGET=3D"_blank">http://www.dejanews.com/</A> &n=
bsp; Search, Read, Discuss, or Start Your =
Own </FONT>=20
</P>
</UL></UL>
</BODY>
</HTML>
------_=_NextPart_001_01BE98C3.65D0EA2C--
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?