Oracle Enterprise Manager / SQL*Plus and Stored Procedures....

From: Mike <mberger_at_skypoint.com>
Date: Wed, 17 Nov 2004 09:36:28 -0600
Message-ID: <3uOdnX1JRYD_7QbcRVnyvw_at_skypoint.com>

[Quoted] Hopefully this is the correct place for this question, I'm new to Oracle (and the Oracle newsgroups). I need to run a stored procedure to insert some missing records. All I know how to do (so far) is run SQL statements in SQL*Plus (starting SQL*Plus) from the Enterprise manager. The stored procedure is
TimeETLAdd (
tcID number,
resID number,
tcResID number,
tlDate1 varchar2,
setDays number,
hrs number,
holidaySet number,
dispID number,
fromTCAdd number,
adjTime number,
newID OUT number)

I made a few guesses as to how to run a stored procedure from SQL*Plus Call TimeETLAdd(11524, 452,452,'13-Aug-2004',0,0,2192,0,0,10) Call TimeETLAdd(11524, 452,452,'13-Aug-2004',0,0,2192,0,0,10,'')

Anyway, the long and the short of it is all my guesses erred. Can I run a SP from SQL*Plus ?
How do I account for the OUT paramater ?

Thanks,
Mike Received on Wed Nov 17 2004 - 16:36:28 CET