SQL*Plus Batch Mode Supported on Windows?
From: Tony Murphy <tony_murphy_at_yahoo.com>
Date: 30 May 2001 07:44:52 -0700
Message-ID: <aa9724e3.0105300644.49a94b2_at_posting.google.com>
echo off
echo Loading Java Stored Procedure
Date: 30 May 2001 07:44:52 -0700
Message-ID: <aa9724e3.0105300644.49a94b2_at_posting.google.com>
hi,
can someone tell me if its possible to run a sql*plus batch file under windows. I get an error
D:\Development\Java\Test\Java-Stored-Procedure\HelloWorld>echo off
Loading Java Stored Procedure
<< was unexpected at this time.
When I run a .bat file containing the following commands:
echo off
echo Loading Java Stored Procedure
sqlplus -silent scott/tiger <<EOF
whenever sqlerror continue
create or replace function HELLOWORLD return VARCHAR2 as
language java name 'Hello.world () return java.lang.String';
/
EOF
looks like syntax that works under unix doesn't work under windows Received on Wed May 30 2001 - 16:44:52 CEST