Skip to Main Content

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!

How to call sql loader ctrl file with in the pl/sql procedure

865976Jul 6 2011 — edited Jul 12 2011
Hi Friends,

I am doing a project related with the transferring data using queues. In the queue , I will get a tab delimited data in the form of CLOB variable/message. I do want to store that dat in the oracle table.
When updating data into the table ,

1. Don't want to write that data into a file.( Want to access directly after dequeueing from the specfic queue).

2. As the data is in tab delimited form, I want to use sql loader concept.

How do I call the sql loader ctrl file with in my pl/sql procedure. When I searched , most of the forums recommending external procedure or Java program.

Please Guide me on this issue. my preferrence is pl sql, But don't know about external procedure . If no other way , I will try Java.

I am using oracle 9.2.0.8.0.

Thanks in advance,
Vimal..
This post has been answered by JustinCave on Jul 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2011
Added on Jul 6 2011
4 comments
746 views