Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling Stored Procedure w/Server Manager

Re: Calling Stored Procedure w/Server Manager

From: Mark Wagoner <mwagoner_at_no.spam.iac.net>
Date: Wed, 19 Aug 1998 13:01:53 GMT
Message-ID: <35dacc9c.592232885@news.iac.net>


Please ignore this post, I fugured it out (I was doing something stupid).

On Tue, 18 Aug 1998 15:22:23 GMT, mwagoner_at_no.spam.iac.net (Mark Wagoner) wrote:

>I am trying to call a procedure from within Server Manager but am not
>having much luck. According to the docs, I should be able to execute
>an anonymous block using the EXECUTE statement. However, I keep
>getting 'identifier xxx must be declared', where xxx is the procedure
>name. The same call works fine within SQL*Plus.
>
>My code is:
>
>execute begin JUKEBOX.DRIVE_LETTER('P:'); end;
>
>As I said, I know the procedure exists and works because I can all it
>from within SQL*Plus.
>
>Any ideas what I am doing wrong?
>
>Thanks
>--
>Mark Wagoner
>To reply, remove no.spam from my e-mail address

--
Mark Wagoner
To reply, remove no.spam from my e-mail address Received on Wed Aug 19 1998 - 08:01:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US