OraFAQ Forum: Forms » oracle applications/interfacing

Home » Developer & Programmer » Forms » oracle applications/interfacing (oracle 9i,10g,11g,)

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

oracle applications/interfacing [message #489412]

Sat, 15 January 2011 17:54

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Q can be deal with data from a backend in front end application which is returning more than one rows at a time for eg select * from emp(backend) is returning more than one row in a front end application. How to handle it in FE?

Report message to a moderator

Re: oracle applications/interfacing [message #489421 is a reply to message #489412]

Sun, 16 January 2011 01:10

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forms does that. Create a data block based on a table, choose a "tabular" layout. Run a form, perform execute query and you'll get all records from a table (as if you ran SELECT * FROM TABLE).

Report message to a moderator

Re: oracle applications/interfacing [message #489462 is a reply to message #489421]

Sun, 16 January 2011 18:45

ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore

Member

Can be use a ref cursor also so that the retunred records gets diaplayed as LOV?

Report message to a moderator

Re: oracle applications/interfacing [message #489493 is a reply to message #489462]

Mon, 17 January 2011 01:51

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know; never tried it.

Report message to a moderator

Previous Topic:	what is best book for oracle10g forms and report for beginners
Next Topic:	Detect browser name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 13:10:44 CDT 2024