I am writing this sample code in Scott/tiger .I am sending a...

Question by arijit
Submitted on 6/16/2004
Related FAQ: [FAQ] Oracle Database FAQ
Rating: Not yet rated	Rate this question:
I am writing this sample code in Scott/tiger .I am sending a pl/sql table to a procedure as an out parameter. I am populating the out parameter in the procedure and want to have the value from another procedure.My package description is like CREATE OR REPLACE package pkg is type tp_varchar2 is table of emp %rowtype index by binary_integer; procedure proc( var1 out tp_varchar2); end; / //package body CREATE OR REPLACE package body pkg is procedure proc (var1 out tp_varchar2) as type d_cur is ref cursor return emp%rowtype; c1 d_cur; i number := 1; begin -- Populate the PL/SQL table from the cursor open c1 for select * from emp; loop exit when c1%NOTFOUND; fetch c1 into var1(i); i := i+1; end loop; close c1; end proc ; end pkg; / declare type tp_varchar2 is table of emp%rowtype index by binary_integer; parameter tp_varchar2; i number := 1; begin pkg.proc(parameter); for i in 1..parameter.last loop dbms_output.put_line('EMPNO : '\|\|parameter(i).EMPNO ); dbms_output.put_line('ENAME : '\|\|parameter(i).ENAME ); dbms_output.put_line('JOB : '\|\|parameter(i).JOB ); dbms_output.put_line('---------------------------'); end loop; end; but the main program showing error...can some one help me ?

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: [FAQ] Oracle Database FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: