Re: [GENERAL] One solution for Packages in Postgre

2010-02-18 Thread venkatrao . b
Thanks a lot Jayadevan. I was unaware of temp table kind of functionality exists in postgres. Now i updated functions as follows- I have one question - if is there any better way of checking if temporary table already created for the given session package(other than one i used to capture as exc

Re: [GENERAL] One solution for Packages in Postgre

2010-02-18 Thread Dimitri Fontaine
venkatra...@tcs.com writes: > I am new to Postgre. We are migrating an oracle db to postgre. In > oracle we have used so many packages. As per my understanding, there > is no oracle package like functionality in postgre. I was just trying > to find some way to migrate ocale packages to postgre. T

Re: [GENERAL] One solution for Packages in Postgre

2010-02-18 Thread Jayadevan M
Hi Posgre Developers, Common table for all packages table Package_Variable_Table :- For Storing Package public and private Variables This table will be common for all packages. to distinguish between different sessions, it uses unique session id. Get and Set functions used to access these