Help with procedure having table as a parameter

From: Maikku <kangasmaki_at_netti.fi>
Date: Wed, 8 Jun 2011 08:27:59 -0700 (PDT)
Message-ID: <4855f740-4ec1-4b4e-9d76-114789a76bc3_at_j23g2000yqc.googlegroups.com>

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
[Quoted] 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).col2); 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 Received on Wed Jun 08 2011 - 17:27:59 CEST