Can a PL/SQL table be created & used in Forms 4.5????
Date: Tue, 9 Mar 1999 18:38:29 -0600
Message-ID: <7c4f0k$22eu$1_at_newssvr03-int.news.prodigy.com>
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01BE6A5C.066FAC70 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject says it all.
I need to be able to "mirror" a db table via a PL/SQL table so that I = can scan rows for specific data.
For instance, I'm in Block1 and have a multiline item based on a table.
I go to row 3 of the multiline and have a need to look at the previous = row and the next row to see it the current rows data "fits" between = these two rows, generally within a When-Validate-item trigger.
Since this trigger has restrictions, (can't use go_block, go_item etc.) = I thought using a PL/SQL table (record based) would fill the bill. = However, I can find no mention of doing this. Creating the table in an = external stored procedure is easy enough but I don't know how (if = possible) to access it.
Anyone have any experience with this that they would care to share??
If so, a short example that demonstrates the method would be most = welcome.
I'm clean out of ideas.
If anyone has a solution or idea of how to accomplish this , please = e-mail me as well if possible.
--=20
Thanks,
Alex
Work E-Mail: Ajentilu_at_mail.donaldson.com Home E-mail: AlexJent_at_prodigy.net
------=_NextPart_000_0013_01BE6A5C.066FAC70 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000080 face=3DArial>Subject says it =
all.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>I need to be able to =
"mirror" a db=20
table via a PL/SQL table so that I can scan rows for specific =
data.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>For instance, I'm in Block1 and =
have a=20
multiline item based on a table.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>I go to row 3 of the multiline =
and have a=20
need to look at the previous row and the next row to see it the current = rows=20
data "fits" between these two rows, generally within a=20
When-Validate-item trigger.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>Since this trigger has =
restrictions, (can't=20
use go_block, go_item etc.) I thought using a PL/SQL table (record = based) would=20
fill the bill. However, I can find no mention of doing this. =
Creating the table in an external stored procedure is easy enough but I =
don't=20
know how (if possible) to access it.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>Anyone have any experience with =
this that=20
they would care to share??</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>If so, a short example that =
demonstrates the=20
method would be most welcome.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>I'm clean out of =
ideas.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>If anyone has a solution or idea =
of how to=20
accomplish this , please e-mail me as well if possible.</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT color=3D#000080 face=3DArial>-- =
<BR><BR>Thanks,<BR>Alex</FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial></FONT> </DIV>
<DIV><FONT color=3D#000080 face=3DArial> Work E-Mail: <A=20
href=3D"mailto:Ajentilu_at_mail.donaldson.com">Ajentilu_at_mail.donaldson.com</=
A></FONT></DIV>
<DIV><FONT color=3D#000080 face=3DArial>Home E-mail: <A=20
href=3D"mailto: AlexJent_at_prodigy.net">=20
AlexJent_at_prodigy.net</A><BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0013_01BE6A5C.066FAC70-- Received on Wed Mar 10 1999 - 01:38:29 CET