Re: Problems on Stored Procedure

In answer to you questions :

1. Oracle does not support run time macro's, DBMS_SQL is your only option.
2. Each user that calls a stored procedure pins a copy / instance of it into his state object tree in the pga and runs it independantly of any other user. Thus each session can run the procedure simultaniously (in parallel).

Regards
David Russell

mouyang_at_yahoo.com wrote in message <6ed980$5kc$1_at_nnrp1.dejanews.com>...
>Hi all,
>I have some questions on PL/SQL:
>1.Is there any mechanism in pl/sql working like "macro replace"
> such as "&" used in foxpro? I donnot want to use package dbma_sql.
>2.When many users call a same stored procedure, Oracle schedule those
> requests running parally or serially?
>Any help thanks.
>
>Ouyang
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Mar 14 1998 - 00:00:00 CST