Hi, I need to call procedure example_proc from anonymous pl/sql
block ? Is it possible ? From package it works fine but I cannot
figure out how to declare out parameter when calling from anonymous pl/
sql block.

create or replace package example_p is
type type_record is record(col1 varchar2(100),col2 varchar2(100));
type type_table is table of type_record;
procedure example_proc(par1 out type_table);
procedure example_caller;
end example_p;
/

create or replace package body example_p is
procedure example_proc(par1 out type_table)
is
begin
par1:= type_table();
par1.extend();
par1(1).col1 := 'test1';
par1(1).col2 := 'test1';
par1.extend();
par1(2).col1 := 'test2';
par1(2).col2 := 'test2';
dbms_output.put_line(par1(1).col1||' '||par1(2).col2);
end;

procedure example_caller is
example_table type_table := type_table();
begin
example_proc(example_table);
dbms_output.put_line('caller :'||example_table(1).col1);
dbms_output.put_line('caller:'||example_table(2).c ol2);
end;

end example_p;
/

set serveroutput on

exec example_p.example_caller;


Byt how do I call example_p.example_proc(par_table) ?

Thanks in advance !

Maija-Leena

Maikku wrote:
something like

declare
example_table example_p.type_table := example_p.type_table();
begin
example_p.example_proc(example_table);
dbms_output.put_line('caller :'||example_table(1).col1);
dbms_output.put_line('caller:'||example_table(2).c ol2);
end;
/


??

Thanks a lot !!! This was a big help for me !!
I didn't know I can use package's type with the package name in front
of it.

Maija-Leena

Maikku wrote:
you can when it is specified in the header, and not in the body (then it would be private)