OraFAQ Forum: Forms » Using Dynamic Ref Cursor in Forms

Home » Developer & Programmer » Forms » Using Dynamic Ref Cursor in Forms

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

Using Dynamic Ref Cursor in Forms [message #168355]

Thu, 20 April 2006 00:24

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

Hi,

any one have any idea how to use a dynamic ref cursor, i.e, at run time i need to pass dynamic where condition to this refcursor, which resides inside the program unit of the form.

Thanks and Regards,

Nirmal Narayanan.

Report message to a moderator

Re: Using Dynamic Ref Cursor in Forms [message #168383 is a reply to message #168355]

Thu, 20 April 2006 02:44

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

Senior Member
Account Moderator

Is this the same question that you asked in http://www.orafaq.com/forum/m/163500/67467/#msg_163500 or are you asking for something different?

David

Report message to a moderator

Re: Using Dynamic Ref Cursor in Forms [message #168430 is a reply to message #168383]

Thu, 20 April 2006 06:57

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

No, i am not mentioning to use of Bulk collect, i want to pass the where condition to the Ref cursor inside the program unit in a form, Is this possible.

Open hdr_cur for 'select * from ' || v_condition;

where v_condition is the string containing the where conditions.

Is this possible in the forms is my problem ?

Thanks and Regards,

Nirmal

Report message to a moderator

Re: Using Dynamic Ref Cursor in Forms [message #168528 is a reply to message #168430]

Thu, 20 April 2006 20:11

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

Senior Member
Account Moderator

Search this forum for 'from clause query'. There is even a working form attached to one of the threads.

David

Actually search for QUERY_DATA_SOURCE_NAME and look at attachment in http://www.orafaq.com/forum/t/53596/67467/

[Updated on: Tue, 16 January 2007 17:32]

Report message to a moderator

Previous Topic:	frm 10247
Next Topic:	Query data Source type IN Oracle Form Builder 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:33:22 CST 2025