Re: Two PL/SQL questions ... Help...

1. Overloading a store procedure within a package is permissible.
2. Values of number1 is honorably registered only within the same session...

    So, two users of different session id would share no values of number1.

Jimmy wrote:

> Hello all,
>
> I have two questions in PL/SQL....
>
> 1) I have a procedure as follows:
>
> procedure testing(id in aaa.id%type, code in aaa.code%type) is
> .....
>
> Can I declare the variable id and code is dynamic? i.e. id sometimes
> is the type of aaa.id, sometimes is the type bbb.id, sometimes is
> ccc.id2...
>
> 2) If I have a package as follows:
>
> create or replace package testing is
> procedure hello;
> end testing;
>
> create or replace package body testing is
> number1 number;
>
> procedure hello is
> begin
> number1 := 0;
> end start1;
> end testing;
>
> If a user A using SQL*Plus (or something else such as Oracle Forms)
> to exec procedure hello in package testing, at the same time, another
> user B also exec hello in package testing using SQL*Plus or Oracle
> Forms. Is the value of variable number1 has different values in two
> executions? i.e. each user see only his copy of value of variable
> number1, user A change number1 value does not affect the value of
> number1 of user B.
>
> Thanks,
> Jimmy
Received on Tue Aug 03 1999 - 21:48:21 CEST