Re: Desperate!Help!

From: Pat Minnis <pminnis_at_maverick.net>
Date: Tue, 11 May 1999 23:59:43 -0500
Message-ID: <IX7_2.45$S4.2236@news.goodnet.com>

I tried PL/SQL tables in Forms45 and it didn't seem to work at all. So I'll assume your trying to use PL/SQL tables in a stored procedure or trigger.

Will to_char to another variable or column work for casting your binary_integer index as varchar2?

For stored procedures & triggers I would think the PL/SQL table would have to be using SGA or PGA memory.

Hope this helps :-)

sganesh <sganesh_at_apple.com> wrote in message news:37379a41_at_discussions...
>
> Hi All,
>
> I am desperatelt fighting the last 1
> week to figure out the following 2 questions.
> If any body can help me, it will be greatly
> appreciated.
>
> 1) Is there anyway, PL/SQL will allow me to
> use the index as a varchar in PL/SQL tables?
>
> 2) When I load a PL/SQL table does it get
> loaded into real memory outside SGA or is it
> loading the SGA of my Oracle instance?
>
> Thanks very much for your help
> Sanjay.
>
>
> --Posted from EarthWeb Discussions. http://discussions.earthweb.com
>
Received on Tue May 11 1999 - 23:59:43 CDT