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 wOOdy-Soft 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
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

J
  • Question
Oracle Simphony - GetPrintedCheck
Replies
0
Views
114
japl93
J
rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
277
rk68
rk68
J
  • Locked
  • Question
Oracle iCare Gift & Loyalty Portlet - Setup and configurations.
Replies
0
Views
125
jandresHDS
J
J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
348
jj10438
J
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
442
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top