Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Doubt....

PL/SQL Doubt....

From: Ajay Agrawal <aka8369_at_tntech.edu>
Date: 1997/09/29
Message-ID: <3430537A.39156A0B@tntech.edu>#1/1

This is a multi-part message in MIME format.
--------------C6D222D7BC79BE007666D983

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Hi Gurus,

I want to pass a table of records from one procedure to another. i am running PL/SQL 2.3 on Oracle 7.3.

when I try to run this simple procedure

create or replace procedure TEST(v_test t_test)

AS
i number := 0;

begin
for i in 1..50 loop
 v_test(i) := i;
end loop;

end;

It gives me a error saying that t_test must be declared. The only way I could do this is to declare the table type in a package header and then use them in the package body.

Does anybody has any idea how to declare Global Variables or Types.

Thanks

Ajay Agrawal
TTU Box 5997
Cookeville, TN 38505
Ph: (931) 372 2898(H)

    (931) 372 3341(O)

http://gemini.tntech.edu/~aka8369
--------------C6D222D7BC79BE007666D983

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ajay Agrawal
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Ajay Agrawal
n:              Agrawal;Ajay
org:            Manufacturing Center
adr:            1210, Maddux Avenue;;;Cookeville;TN;38501;USA
email;internet: aka8369_at_tntech.edu
title:          Research Assistant
tel;work:       931 372 3341
tel;home:       931 372 2898

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------C6D222D7BC79BE007666D983--
Received on Mon Sep 29 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US