Home » Developer & Programmer » Forms » Get all parameter from a parameter list
Get all parameter from a parameter list [message #364348] Mon, 08 December 2008 01:56 Go to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Get all parameter from a parameter list [message #364562 is a reply to message #364348] Tue, 09 December 2008 01:43 Go to previous messageGo to next message
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.
Re: Get all parameter from a parameter list [message #364775 is a reply to message #364562] Wed, 10 December 2008 00:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Get all parameter from a parameter list [message #366252 is a reply to message #364348] Fri, 12 December 2008 05:16 Go to previous messageGo to next message
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.

Re: Get all parameter from a parameter list [message #375819 is a reply to message #366252] Mon, 15 December 2008 00:51 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If it is written in PL/SQL then the parameters are listed as part of the 'declare'.

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


Current Time: Mon Dec 05 13:01:20 CST 2016

Total time taken to generate the page: 0.05283 seconds