| problem with running query in the application [message #447675] |
Wed, 17 March 2010 05:30  |
swapna053
Messages: 18
Registered: March 2010
|
Junior Member |
|
|
Hello ,
I am using oracle 10g apex 3.2.
I have assosiated 2 schema "vpmys and vp" with one workspace.
In the application , i created a new page of report ,which is assosiated with one schema called "vp" and i wish to run this query
select * from vpmys.t_devotees
minus
select * from vp.t_devotees
Same database dmp is installed in both schema except that the no of rows may be more or less in one database.So first i need to know the added rows and what are they and then insert the same no of rows.
But this doesnt run in the application.
But it runs in the SQL Command window.
Thanks
Swapna
|
|
|
|
|
|
|
|
|
|
| Re: problem with running query in the application [message #447839 is a reply to message #447823] |
Thu, 18 March 2010 03:52  |
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
|
Senior Member |
 
|
|
Hello :
I tried with different schema. problem is you can assign multiple schema to a specific workspace but you can assign only a default schema of a single user.
So, when you execute the query it finds and check the default schema.
Hope i can give you the way out. Let me work on it and I will let you know.
Thank you.
-- kamal Hossain
[Updated on: Thu, 18 March 2010 03:55] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
