Two PL/SQL questions ... Help...

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Tue, 03 Aug 1999 00:49:46 -0700
Message-ID: <37A69F1A.848B6EB0@comp.polyu.edu.hk>

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 - 02:49:46 CDT