RE: How do you run PLSQL in batch?

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 21 Dec 2000 14:32:08 -0600
Message-Id: <10717.125173@fatcity.com>

Here is the code. I am running on NT just using a SQL*PLUS execute in batch using @job. I get an error on the declare line.

set serveroutput on
declare

v_errbuf            varchar2(2000);
v_retcode           varchar2(1);

BEGIN

  KM_LC_VEN_PKG.CHEM_VEN_LOAD_LC
     (p_errbuf          => v_errbuf,
      p_retcode         => v_retcode,
      p_begin_date      => '01-JAN-1900'
     );

EXCEPTION
  WHEN OTHERS THEN
    dbms_output.put_line(v_errbuf);
    dbms_output.put_line(substr(SQLERRM,1,200)); END; -----Original Message-----
From: Eric D. Pierce [mailto:PierceED_at_csus.edu] Sent: Thursday, December 21, 2000 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: How do you run PLSQL in batch?

some obvious q's:

Why can't sql-plus work?

Platform????????

It works a little differently on IBM mainframe vs. VMS vs. Unix vs. Windows vs. etc :)

The generic technique: get you code working in a script of some kind (typically that can be invoked from command line), and then use a scheduler, which may or may not be an OS utility.

regards,
ep

On 21 Dec 2000, at 11:43, Smith, Ron L. wrote:

Date sent:      	Thu, 21 Dec 2000 11:43:49 -0800
To:             	Multiple recipients of list ORACLE-L

<ORACLE-L_at_fatcity.com>

> Can someone tell me how to run PLSQL in batch? I tried SQL*PLUS but that
> doesn't work. Sorry, I'm not a developer.
...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 21 2000 - 14:32:08 CST