Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle packages

Status
Not open for further replies.
sweetleaf

sweetleaf

Programmer
Jan 16, 2001
439
0
0
CA
hi!!

say i have 5 stored procedures - each one reads data and then creates .txt files in a chosen directory. if i want to combine all five stored procedures into one, how do i go about this?

thanks for any advice,
 
Sort by date Sort by votes
Hi,

You can have a look at DBMS_SQL package provided by Oracle
this is basically to execute dynamic sqls . U can pass
procedure & directory name as parameteres...

Manoj
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
72
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
92
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
70
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.
Replies
3
Views
64
Livia8
Livia8
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
81
Aung Thurein Tun
Aung Thurein Tun

Part and Inventory Search

Sponsor

Back
Top