This discussion is archived
1 Reply Latest reply: Jun 26, 2012 11:04 AM by riedelme RSS

How ti call sql*plus script from a pl/sql package (procecdure)

emss Newbie
Currently Being Moderated
Can a .sql sql*plus script be called from a pl/sql package? I so, can someone provide a brief example?
  • 1. Re: How ti call sql*plus script from a pl/sql package (procecdure)
    riedelme Expert
    Currently Being Moderated
    emss wrote:
    Can a .sql sql*plus script be called from a pl/sql package? I so, can someone provide a brief example?
    Not really - there is no easy interface.

    There are interfaces that are not easy. You could instead
    * use DBMS_SCHEDULER to create a host call to execute an OS script to execute the SQL*PLUS script
    * use a java stored procedure to do the same thing

    Do a web search to find examples

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points