Reg. Postgres utility for fetching multiple rows from DB

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Reg. Postgres utility for fetching multiple rows from DB

Remya DJ
Dear All,

We were using Oracle DB and in the process of migrating to postgres DB.

In oracle, we used packages and procedures for fetching multiple row from different tables. When we try to do the same in pistgres getting error as "Assigning non-composite value to composite value". 

Can you give sample code based on which packages/procedures can be used. If we have to use another way, please do guide.

Regards,
Remya