Home » Developer & Programmer » Forms » POPULATE_GROUP_WITH_QUERY by using procedure (Oracle Developer Suite 10g,Win 7 Professional 64 bit)
POPULATE_GROUP_WITH_QUERY by using procedure [message #643088] Mon, 28 September 2015 17:05 Go to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi All

I need to create a dynamic records groups that get data from my calling procedure, can someone guide me how to call procedure with POPULATE_GROUP_WITH_QUERY built...
POPULATE_GROUP_WITH_QUERY ('My_group',procedure(a,b));

Regards
Shumail

[Updated on: Mon, 28 September 2015 17:06]

Report message to a moderator

Re: POPULATE_GROUP_WITH_QUERY by using procedure [message #643096 is a reply to message #643088] Tue, 29 September 2015 02:37 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Answer depends on what the procedure actually does.
So what does it do?
Re: POPULATE_GROUP_WITH_QUERY by using procedure [message #643099 is a reply to message #643096] Tue, 29 September 2015 04:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
To clarify a point: Functions can generally be used where variables can be used. Procedures can't.
So what you've put above is basically meaningless.
Re: POPULATE_GROUP_WITH_QUERY by using procedure [message #643105 is a reply to message #643099] Tue, 29 September 2015 08:22 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Quote:
I need to create a dynamic records groups that get data from my calling procedure...

You can't use POPULATE_GROUP_WITH_QUERY() built-in like this. You need to get the SQL provided by the procedure in a Variable first, then pass the variable to the built-in. You might want to visit the Forms Help topic on the POPULATE_GROUP_WITH_QUERY() built-in for all of the rules on how to use the built-in.

Craig...
Previous Topic: Having problems with summing values
Next Topic: old windows xp fourms is not open in windows 7 unother pc
Goto Forum:
  


Current Time: Thu Mar 28 05:40:58 CDT 2024