Home » Infrastructure » Unix » Unix shell script to run sqlplus procedure with IN parameter
Unix shell script to run sqlplus procedure with IN parameter [message #137285] Wed, 14 September 2005 06:38
shaza
Messages: 4
Registered: August 2005
Location: London UK
Junior Member
Hi,

I am attempting to run a procedure in a shell script:


#!/bin/ksh -x
sqlplus scott/tiger@jsueft00 <</*
set serveroutput on
DEFINE p_days=1
exec extr_eba(&p_days);
exec extr_edc(&p_days);
/*


But I don't seem to be successfully passing the number '1' to the p_days IN parameter for either of these procedures.


Many thanks,
shaza

Report message to a moderator

Previous Topic: Migrating Oracle 9i Enterprise Edition to oracle 9i standard edition
Next Topic: Porting from UNIX to NT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 03 05:31:35 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.