Re: Unable to create Stored Procedure

Hi! Are you running the script from dbaccess or isql ? isql doesn't support procedures, so you have to create the procedure from dbaccess. And, if you are running the script from dbaccess you can post the procedure code without cuts so we can look at it. Best Regards, Octav glynb@bicceri.demon.co.uk wrote: > 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