OraFAQ Forum: Forms » Get all parameter from a parameter list

Home » Developer & Programmer » Forms » Get all parameter from a parameter list

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Get all parameter from a parameter list [message #364348]

Mon, 08 December 2008 01:56

raywong9i
Messages: 40
Registered: April 2008

Member

Hi all,

My form have a Parameter List which will have different number of parameters added to it based on different situations.

The parameter list will then pass to a procedure, does anyone know How to list out all the parameters from the parameter list
?

I mean, as the parameter name, parameter value & the number of parameter are changed in runtime, that's y I don't know how to show all the parameters from the list.

Thanks!

[Updated on: Mon, 08 December 2008 04:43]

Report message to a moderator

Re: Get all parameter from a parameter list [message #364525 is a reply to message #364348]

Tue, 09 December 2008 00:14

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If the parameter is not defined in the recieving form you will not be able to use it. So, get the list defined and add them ALL to the 'parameters' block.

David

Report message to a moderator

Re: Get all parameter from a parameter list [message #364562 is a reply to message #364348]

Tue, 09 December 2008 01:43

raywong9i
Messages: 40
Registered: April 2008

Member

Thanks, but I am not passing the list to a new form, I am passing
the list to a procedure. BUt in that procedure I need to see the parameters inside the parameter list.

Report message to a moderator

Re: Get all parameter from a parameter list [message #364775 is a reply to message #364562]

Wed, 10 December 2008 00:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then this is not a Forms question. You need to search for information on the language in which you are writing your procedure.

David

Report message to a moderator

Re: Get all parameter from a parameter list [message #366252 is a reply to message #364348]

Fri, 12 December 2008 05:16

raywong9i
Messages: 40
Registered: April 2008

Member

Hi David,
this is really a form question, the procedure is written in PL/SQL and it is in the attached library.

Report message to a moderator

Re: Get all parameter from a parameter list [message #375819 is a reply to message #366252]

Mon, 15 December 2008 00:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If it is written in PL/SQL then the parameters are listed as part of the 'declare'.

David

Report message to a moderator

Previous Topic:	import data from excel and process via oracle forms 10g
Next Topic:	Hierarchical tree icon size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 09:09:04 CST 2025