Home » Developer & Programmer » Forms » Data block based on join, tables in different schema
Data block based on join, tables in different schema [message #586259] Wed, 05 June 2013 00:24 Go to next message
NewToOracle10g
Messages: 31
Registered: April 2009
Location: Adelaide
Member
Hi

I have to create a data block which is is based on two tables. Both are in different schema.
if I create indivial data block, like select * from table1 and select * from table2, both data blocks work fine. but when I try to do
select col1, col2.... from table1, table2
where table1.colkey = table2.colkey
is it returning unable to perform query. I f I run the query forms has formed in sql it returns values.
Is there any work around to deal with this?
I have already asked about views but dba not ready to create view.
Regards,
Leena
Re: Data block based on join, tables in different schema [message #586260 is a reply to message #586259] Wed, 05 June 2013 00:35 Go to previous messageGo to next message
azamkhan
Messages: 484
Registered: August 2005
Senior Member
Did you created public synonmys and grant public access to both tables?
Re: Data block based on join, tables in different schema [message #586269 is a reply to message #586260] Wed, 05 June 2013 02:26 Go to previous messageGo to next message
Littlefoot
Messages: 19329
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Public? Why public?

Leena
it is returning unable to perform query

When that happens, navigate to Help menu and choose Display error. Read what's in there. If you don't understand it and can't fix the error, post the "display error" results over here.
Re: Data block based on join, tables in different schema [message #594322 is a reply to message #586269] Tue, 27 August 2013 07:52 Go to previous message
NewToOracle10g
Messages: 31
Registered: April 2009
Location: Adelaide
Member
Apologies for late reply. Solution to the problem is very illogical but it worked. In key next trigger of the control block I had to write separate cursor s and populate next block.
Previous Topic: form development
Next Topic: push button associated with record
Goto Forum:
  


Current Time: Tue Jul 29 19:19:41 CDT 2014

Total time taken to generate the page: 0.13050 seconds