hi folks,
can i create a pla/sql table which will have a type like x%rowtype, x being a table name which is an input parameter to the proc.
i'll tell u my requirement in detail -

i will have a materialized view in my schema which is built on a prebuilt table. now due to some problems in the master at the source side (which is in a different instance), the table is rebuilt from a backup and reimported in my schema - and the replication stopped.
i have to find out the difference in data between the mview and the imported table and update another table which will have the same structure with an additional 2 columns.
now the names of the tables will be coming to me dynamically. the mview name is mv_ and the table where the difference is to be loaded is d_.
i thought that i would bulk collect the difference in a collection variable and then load d_.
is this approach correct?
plzz help.

thanks and regards.
Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules



Click Here to Expand Forum to Full Width