|
IDS Forum
RE: Error in Execute Procedure (Error # 674)
Posted By: ART KAGEL, BLOOMBERG/ 731 LEXIN Date: Friday, 14 January 2005, at 8:41 a.m.
In Response To: RE: Error in Execute Procedure (Error # 674) (Prashant Shirude )
Informix DOES indeed support return values from procedures, just not with the same syntax and new procedures returning values should use the keyword FUNCTION instead of PROCEDURE (though the older keyword is still supported). The OUT parameter type is ONLY for external UDFs created using Java or C not for SPL routines which must use the RETURNING (or RETURNS) clause. The syntax would be:
CREATE FUNCTION test_proc( call INT ) RETURNING INT; DEFINE retvar INT; .. RETURN retvar; END FUNCTION;
Art S. Kagel
----- Original Message ----- From: Prashant Sh.... <PShirude@manh.com> At: 1/13 23:47
> Actually I was converting Oracle Procedure into Informix. > > > > In Oracle: > > CREATE OR REPLACE PROCEDURE test_proc(val1 in NUMBER, r_cnt OUT NUMBER); > > > > I think, in Oracle r_cnt OUT returns the value from where it called. > > > > Converted in Informix: Create procedure test_proc(val1 INT, OUT r_cnt INT) > > > > Informix SPL doesn't support to return value. I think, I may need to write > function. > > > > Prashant > > > > -----Original Message----- > From: Gregory S. Williamson [mailto:gsw@globexplorer.com] > Sent: Thursday, January 13, 2005 6:21 PM > To: Prashant Shirude; ids@iiug.org > Subject: RE: Error in Execute Procedure (Error # 674) [4008] > > > > > > You seem to have created a proecure with two paramaters, although the syntax > is odd enough I wonder what is really going on ... > > > > The correct syntax for returning something from a procedure is something > like: > > CREATE FUNCTION upd_billing_job (p_jobid INTEGER, p_early_time DATETIME YEAR > TO SECOND, p_last_time DATETIME YEAR TO SECOND) > > RETURNING INTEGER; > > DEFINE someval INTEGER; > > <DEFINES, including > > > > > <CODE> > > RETURN(some_val); > > END FUNCTION; > > > > Your procedure lack a proper RETURNING clause ... as it is you need to give > the procedure two integers in your call ... > > > > HTH, > > Greg Williamson > > DBA > > GlobeXplorer LLC > > > > -----Original Message----- > > From: Prashant Sh.... [mailto:PShirude@manh.com] > > Sent: Thu 1/13/2005 2:52 PM > > To: ids@iiug.org > > Cc: > > Subject: Error in Execute Procedure (Error # 674) [4008] > > Hi All, > > > > Here is the procedure: > > > > create procedure test_proc(val1 INT, OUT r_cnt INT) > > > > define x char(10); > > define r_cnt INT; > > LET r_cnt = 0; > > > > begin > > set debug file to "test_proc.out"; > > trace "begin trace"; > > trace on; > > > > IF val1 = 3 THEN > > LET x = 'True-3'; > > LET r_cnt = val1; > > ELSE > > LET x = 'False-3'; > > LET r_cnt = 0; > > END IF; > > > > trace off; > > end > > end procedure; > > > > => EXECUTE PROCEDURE test_proc(3); > > Error: (674) Routine (test_proc) can not be resolved. > > > > Is anything wrong in Execute Procedure statement? Help needed. > > > > Prashant > > > > -----Original Message----- > > From: June C. Hunt [mailto:june_c_hunt@hotmail.com] > > Sent: Thursday, January 13, 2005 4:43 AM > > To: ids@iiug.org > > Cc: Prashant Shirude > > Subject: RE: How to execute procedure [3999] > > > > "Prashant Sh...." <PShirude@manh.com> wrote: > > > > > >CREATE PROCEDURE AUTO_APPROVE_SHIPMENT > > > (vshpid LIKE SHIPMENT.SHIPMENT_ID, > > > OUT vPassFail INT > > > ) > > > > > >How to execute above procedure when there is one Input and one out > > >parameter. > > > > Please see the IBM Informix Guide to SQL: Tutorial. You will find it here, > > if you don't already have it - > > http://www-306.ibm.com/software/data/informix/pubs/library/list2.html#G > > > > There is an entire chapter devoted to creating and using SPL routines. > > You'll want to review the format for creating a procedure (function) that > > returns a value, and there are several ways to execute a procedure or > > function. You haven't provided enough information about how you will be > > using the procedure to give you the syntax for execution. > > > > -- > > June Hunt > > > > > > > > > > > ------_=_NextPart_001_01C4F9F2.98346CB8 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = > xmlns:w=3D"urn:schemas-microsoft-com:office:word" = > xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = > xmlns=3D"http://www.w3.org/TR/REC-html40"> > > <head> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > > > <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> > <o:SmartTagType = > namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" > name=3D"PersonName"/> > <!--[if !mso]> > <style> > st1\:*{behavior:url(#default#ieooui) } > </style> > <![endif]--> > <style> > <!-- > /* Style Definitions */ > p.MsoNormal, li.MsoNormal, div.MsoNormal > {margin:0in; > margin-bottom:.0001pt; > font-size:12.0pt; > font-family:"Times New Roman";} > a:link, span.MsoHyperlink > {color:blue; > text-decoration:underline;} > a:visited, span.MsoHyperlinkFollowed > {color:purple; > text-decoration:underline;} > p.MsoPlainText, li.MsoPlainText, div.MsoPlainText > {margin:0in; > margin-bottom:.0001pt; > font-size:10.0pt; > font-family:"Courier New";} > @page Section1 > {size:8.5in 11.0in; > margin:1.0in 77.95pt 1.0in 77.95pt;} > div.Section1 > {page:Section1;} > --> > </style> > > </head> > > <body lang=3DEN-US link=3Dblue vlink=3Dpurple> > > <div class=3DSection1> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Actually I was converting Oracle Procedure into = > Informix.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><b><font size=3D2 face=3D"Courier New"><span > style=3D'font-size:10.0pt;font-weight:bold'>In Oracle: = > <o:p></o:p></span></font></b></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>CREATE OR REPLACE PROCEDURE test_proc(val1 in NUMBER, r_cnt OUT = > NUMBER);<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>I think, <b><span style=3D'font-weight:bold'>in Oracle r_cnt = > OUT returns</span></b> > the value from where it called.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><b><font size=3D2 face=3D"Courier New"><span > style=3D'font-size:10.0pt;font-weight:bold'>Converted in = > Informix</span></font></b>: > Create procedure test_proc(val1 INT, OUT r_cnt INT)<o:p></o:p></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Informix SPL doesn't support to return value. I think, I may = > need to > write function.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Prashant <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>-----Original Message-----<br> > From: Gregory S. Williamson [mailto:gsw@globexplorer.com] <br> > Sent: Thursday, January 13, 2005 6:21 PM<br> > To: <st1:PersonName w:st=3D"on">Prashant Shirude</st1:PersonName>; = > ids@iiug.org<br> > Subject: RE: Error in Execute Procedure (Error # 674) [4008] = > </span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>You seem to have created a proecure with two paramaters, = > although the > syntax is odd enough I wonder what is really going on = > ..<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>The correct syntax for returning something from a procedure is > something like:<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>CREATE FUNCTION upd_billing_job (p_jobid INTEGER, p_early_time = > DATETIME > YEAR TO SECOND, p_last_time DATETIME YEAR TO = > SECOND)<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> RETURNING = > INTEGER;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>DEFINE someval INTEGER;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><DEFINES, including<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><CODE><o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>RETURN(some_val);<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>END FUNCTION;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Your procedure lack a proper RETURNING clause ... as it is you = > need to > give the procedure two integers in your call = > ..<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>HTH,<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Greg Williamson<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>DBA<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>GlobeXplorer LLC<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>-----Original Message-----<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>From: Prashant Sh.... = > [mailto:PShirude@manh.com]<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Sent: Thu 1/13/2005 2:52 PM<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>To: ids@iiug.org<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Cc: <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Subject: Error in Execute Procedure (Error # = > 674) > [4008] <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Hi All,<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Here is the procedure:<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>create procedure test_proc(val1 INT, OUT r_cnt = > INT)<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>define x char(10);<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>define r_cnt INT;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>LET r_cnt =3D 0;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>begin<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> set debug file to = > "test_proc.out";<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> trace "begin = > trace";<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> trace on;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> IF val1 =3D 3 THEN<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> LET x =3D = > 'True-3';<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> LET r_cnt =3D val1; = > <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> ELSE <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> LET x =3D = > 'False-3';<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> LET r_cnt =3D = > 0;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> END IF;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> trace off;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>end<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>end procedure;<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>=3D> EXECUTE PROCEDURE = > test_proc(3);<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'> Error: (674) Routine (test_proc) can not be resolved.<o:p>= > </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Is anything wrong in Execute Procedure statement? Help = > needed.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Prashant <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>-----Original Message-----<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>From: June C. Hunt [mailto:<st1:PersonName = > w:st=3D"on">june_c_hunt@hotmail.com</st1:PersonName>] > <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Sent: Thursday, January 13, 2005 4:43 = > AM<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>To: ids@iiug.org<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Cc: <st1:PersonName w:st=3D"on">Prashant = > Shirude</st1:PersonName><o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Subject: RE: How to execute procedure = > [3999]<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>"Prashant Sh...." <PShirude@manh.com> = > wrote:<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>>CREATE PROCEDURE = > AUTO_APPROVE_SHIPMENT<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>> = > (vshpid LIKE > SHIPMENT.SHIPMENT_ID,<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>> OUT vPassFail = > INT<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>> )<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>>How to execute above procedure when there is one Input and = > one out<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>>parameter.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>Please see the IBM Informix Guide to SQL: Tutorial. You = > will find > it here, <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>if you don't already have it -<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>http://www-306.ibm.com/software/data/informix/pubs/library/list2= > .html#G<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span style=3D= > 'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>There is an entire chapter devoted to creating and using SPL > routines. <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>You'll want to review the format for creating a procedure = > (function) > that <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>returns a value, and there are several ways to execute a = > procedure or <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>function. You haven't provided enough information about = > how you > will be <o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>using the procedure to give you the syntax for = > execution.<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>--<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'>June Hunt<o:p></o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > <p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span = > style=3D'font-size: > 10.0pt'><o:p> </o:p></span></font></p> > > </div> > > </body> > > </html> > > ------_=_NextPart_001_01C4F9F2.98346CB8-- > > ------=_NextPartTM-000-a73725dc-bbb0-4bbe-a192-7e5a42693517--
Messages In This Thread
- Error in Execute Procedure (Error # 674)
Prashant Shirude -- Thursday, 13 January 2005, at 5:52 p.m.
- RE: Error in Execute Procedure (Error # 674)
Gregory S. Williamson -- Thursday, 13 January 2005, at 6:25 p.m.
- Re: Error in Execute Procedure (Error # 674)
Obnoxio The Chav -- Thursday, 13 January 2005, at 8:16 p.m.
- RE: Error in Execute Procedure (Error # 674)
Prashant Shirude -- Thursday, 13 January 2005, at 11:41 p.m.
- RE: Error in Execute Procedure (Error # 674)
Obnoxio The Chav -- Friday, 14 January 2005, at 3:25 a.m.
- RE: Error in Execute Procedure (Error # 674)
ART KAGEL, BLOOMBERG/ 731 LEXIN -- Friday, 14 January 2005, at 8:41 a.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|