Re: PL/SQL procedure help

The easiest way to do this is to use the dbms_sql (dynamic sql) package.

If you need some samples then please ask.

Regards,

William.  

EuroNet*Internet BV, http://www.euronet.nl/ Wm. G. Urquhart, Oracle DBA
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam T:+31 20 5355263, F:+31 20 5355400, E: williamu_at_nl.euro.net M:+31 06 28206038 ICQ: 56047340 In article <3908c5e6$0$215_at_fountain.mindlink.net>, gennadyb_at_halcosoftware.com says...
> Hello,
> I have a set of tables for which I need to perform a procedure like this:
>
> create package my_test as
> cursor dept_cv is select * from dept;
> type DeptCurTyp is ref cursor return dept%rowtype;
> PROCEDURE My_proc;
> End my_test;
>
> create package body my_test as
> PROCEDURE My_proc is
> v_deptrow dept%rowtype;
> begin
> open dept_cv;
> loop
> fetch dept_cv into v_deptrow;
> if dept_cv%found then
> --do something
> else
> exit;
> end if;
> end loop;
> close dept_cv;
> commit;
> end My_proc;
> End my_test;
>
> How could I change this code to except different table names
> as a parameter which I pass from VB application ?
>
> Thanks,
> Gennady
>
>
>
 

--