Re: PL/SQL block, won't accept accept

On Jan 29, 7:06 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:

[...]

> Mitch.Yes, EXECUTE in SQL*Plus wraps its arguments into BEGIN ... END; block
> automatically. And SQL*Plus variables, when used as arguments, should
> be prefixed with '&' or whatever character you defined with SET DEFINE
> command:
>
> EXECUTE TTT_MoveProc('&TTT_PlayerMoveColumn', '&TTT_PlayerMoveRow');
>
> (note they are surrounded by quotes - SQL*Plus simply replaces the
> variables with whatever you typed in, so it's up to you to typecast
> the input properly, in this case - to strings.) And you don't need to
> create the procedure again for each call - once compiled it will stay
> in the database until you drop it.
>
> Again, more reading (assuming you're on 10g R2):http://www.oracle.com/pls/db102/to_toc?pathname=server.
> 102%2Fb14357%2Ftoc.htm
>
> Please RTFM, at least those referenced, before posting more questions.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

Thanks Vladimir.

I'm still on 9i, but that didn't stop me having a go through the link you gave me. I'll be sure to dig a little deeper next time.

Thanks again.

Mitch. Received on Tue Jan 30 2007 - 03:36:04 CST