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

From: Jimmy <>
Date: Tue, 03 Aug 1999 00:49:46 -0700
Message-ID: <>

Hello all,

    I have two questions in PL/SQL....

  1. I have a procedure as follows:
[Quoted]      procedure testing(id in, code in aaa.code%type) is

    Can I declare the variable id and code is dynamic? i.e. id sometimes is the type of, sometimes is the type, sometimes is ccc.id2...

[Quoted]     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
         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.

Jimmy Received on Tue Aug 03 1999 - 09:49:46 CEST

Original text of this message