Re: [GENERAL] Need help on SP

2007-01-17 Thread Albe Laurenz
> I want to store count(*) of a table in a variable , > for that I have declared a variable and wrote a > statment but it is giving me error. > can anybody please help me.. > > CREATE OR REPLACE FUNCTION foreign_keys_tables(OUT > par_result charecter varying, IN par_tablename > character varying

Re: [GENERAL] Need help on SP

2007-01-16 Thread Martijn van Oosterhout
On Tue, Jan 16, 2007 at 05:08:29AM -0800, Ashish Karalkar wrote: > Hello All, > I want to store count(*) of a table in a variable , > for that I have declared a variable and wrote a > statment but it is giving me error. > can anybody please help me.. It would help immensly if you showed us the act

[GENERAL] Need help on SP

2007-01-16 Thread Ashish Karalkar
Hello All, I want to store count(*) of a table in a variable , for that I have declared a variable and wrote a statment but it is giving me error. can anybody please help me.. CREATE OR REPLACE FUNCTION foreign_keys_tables(OUT par_result charecter varying, IN par_tablename character varying , IN