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

Hi Jimmy,

1. overloading procedures is allowed. This is the way dbms_output and dbms_sql works procedure testing (id in aaa.id%type, code in aaa.code%type) procedure testing (in number, code in varchar2) should work without problem.

2)
They will have their local copy.

Hth,

Sybrand Bakker, Oracle DBA

Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in message news:37A69F1A.848B6EB0_at_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 Mon Aug 02 1999 - 12:48:33 CDT