Two PL/SQL questions... Help...
Date: Tue, 03 Aug 1999 01:03:11 -0700
Message-ID: <37A6A23E.29333FC0_at_comp.polyu.edu.hk>
[Quoted] Hello all,
I have two questions in PL/SQL....
- 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 - 10:03:11 CEST