Home » Developer & Programmer » Forms » varray parameter from forms to oracle
varray parameter from forms to oracle [message #84348] Sat, 06 March 2004 10:45 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
Hi,

I have created a srotred procedure in the Oracle9i that accepts varray as input parameter. When i call this procedure from PL/SQL, it works fine. But i am having problem to access this procedure from Forms 9i.

I have declared a type of varray in Oracle but it is not recognized in Forms. Is there any way out?

Thanks in advance for help.

Mahesh

Report message to a moderator

Re: varray parameter from forms to oracle [message #85178 is a reply to message #84348] Mon, 07 June 2004 10:58 Go to previous message
Markus
Messages: 3
Registered: June 2004
Junior Member
Yes, that's actually very easy. You simply need to create a global variable and store the database in it.

Because global variables are held in the RAM, access to the database will also be much faster.

Report message to a moderator

Previous Topic: Creating a Listner .
Next Topic: hierarchical tree and ordering
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 15:25:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.