SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

excel sheet as input param in stored procedure

913578Mar 18 2014 — edited Mar 18 2014

Hi,

I have to write a stored procedure which takes data backup of specific tables.

In this process I recieve a excel file having two columns in it,1.table_name 2.Indictor(Y/N)

there are about 300-350 tables, every they send the sheet with some tables as Y and some as N

i have to write the data of tables having Y indicator to a separate excel file creating with that table name.

Writing to the new files is not a problem to me, but how i can read the excel fie coming, do we really have that provision of taking excel as input?

Please suggest me.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2014

Added on Mar 18 2014

4 comments

530 views