Re: [GENERAL] error in open cursor

2007-01-12 Thread Alban Hertroys
Ashish Karalkar wrote: > Hello all, > I am getting a syntax error near open cursor, > can anybody please point me what is missing. i am > using Postgresql 8.2 > > CREATE OR REPLACE FUNCTION > sp_gen_foreign_keys_tables(OUT par_result integer, OUT > par_childtables text, IN par_colname character va

[GENERAL] error in open cursor

2007-01-12 Thread Ashish Karalkar
Hello all, I am getting a syntax error near open cursor, can anybody please point me what is missing. i am using Postgresql 8.2 CREATE OR REPLACE FUNCTION sp_gen_foreign_keys_tables(OUT par_result integer, OUT par_childtables text, IN par_colname character varying , IN par_colvalue integer) AS $BO