Home » Developer & Programmer » Forms » Retrive many rows into a data block??
Retrive many rows into a data block?? [message #338890] Wed, 06 August 2008 03:36 Go to next message
Messages: 11
Registered: July 2008
Junior Member
Hi All,

I have a select statement which returns all the Childs of a specific project so the select statement will return many rows.

I want to add a data block in the forms to display these rows in the screen (I want this block in purpose of displaying the results only) from the select statement.

I tried to add a non data base data block and I put the select query in the main block as (post query) to retrieve the rows in the non data block items.

After I do query the non data block retrieve only one record and the form raise ORA-01403: exact fetch returns more than requested number of rows.

So how can I make the non data block multi record to display all the results from the select query??
Re: Retrive many rows into a data block?? [message #338921 is a reply to message #338890] Wed, 06 August 2008 04:50 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wouldn't you rather create a simple master-detail form? Doing so, you wouldn't have to base the detail block on SELECT statement.

If you, however, choose to continue the path you've described, then base this block's Query Data Source Type must be "FROM clause query" which would be written into the Query Data Source Name block's property. You'd also have to manually create all Query Data Source Columns, as well as ever item in the block. Quite a tedious, dull job.

If possible, I'd suggest you to use master-detail form created by Wizard.
Previous Topic: Really Need Help
Next Topic: Web hyperlink in Forms 6i
Goto Forum:

Current Time: Tue Oct 25 04:05:31 CDT 2016

Total time taken to generate the page: 0.05705 seconds