Do you have the SET TERM? Greetings.
Walter. On Sat, Jan 4, 2014 at 2:41 AM, <venussof...@gmail.com> wrote: > > > Hi Walter > > Okay I upgraded to FB 2.5.2.26540. I have successfully created the SPs > Parser and Crear_Tabla_Pivot but when I try to create the SP called > ACTUALIZAR_TABLA_PIVOT (I tried the one from your web page as well as the > one you sent me as a download) I get the error: > > Executing statement... > > Error: *** IBPP::SQLException *** > Context: Statement::Execute( > > CREATE PROCEDURE ACTUALIZAR_TABLA_PIVOT( > tcTablaPivot VARCHAR( 28), > tcVista VARCHAR( 28), > tcPr... > ... > ...STATEMENT lcActualizar; > END > END > > END ) > Message: isc_dsql_execute2 failed > > SQL Message : -607 > This operation is not defined for system tables. > > Engine Code : 335544351 > Engine Message : > unsuccessful metadata update > STORE RDB$PROCEDURES failed > Malformed string > > > Total execution time: 0.015s > > > Surprisingly I was able to create this SP well in FB 2.1.4! Please advise. > > Thanks and regards > Bhavbhuti > > >