1 Reply Latest reply: Jun 26, 2012 1:04 PM by riedelme RSS

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

    emss
      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
          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