| ORA-02063: preceding line from [message #523194] |
Fri, 16 September 2011 02:54  |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
I am getting the below error when executed the query below in production database.
The database version of both the database is 10.2.0.4
ORA-01008: not all variables bound
ORA-02063: preceding line from DBLINK.PROD.NIC.CMS
select count(*)
from order_tbl@DBLINK.PROD.NIC.CMS a
group by a.col1
having count(distinct a.col2) > 1
the same sql is working fine in dev environment.
Is this a bug?
Regards
Ved
|
|
|
|
|
|
|
|
|
|
| Re: ORA-02063: preceding line from [message #523218 is a reply to message #523215] |
Fri, 16 September 2011 04:36  |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
Its just a simple select.
The remote database is Oracle 10.2.0.4. The version is same for the two database.
If I query like below there is no error and getting the output.
select count(*)
from order_tbl@DBLINK.PROD.NIC.CMS a
group by a.col1
But when I used having count(*)>1 then I am getting the error. I am executing the sql in
pl/sql developer. In other DEV environment it working fine.
Regards
Ved
[Updated on: Fri, 16 September 2011 04:37] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: ORA-02063: preceding line from [message #523233 is a reply to message #523223] |
Fri, 16 September 2011 05:44 |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
What I meant that I provided the correct column name of the table.
What is the RBDMS and version target of the db link?
> Oracle 10.2.0.4
Both the database is same oracle version
Regards
Ved
|
|
|
|
|
|
| Re: ORA-02063: preceding line from [message #523240 is a reply to message #523237] |
Fri, 16 September 2011 06:09 |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
My apologies!! Due to some restrictions I am unable to provide the test case in the database 10.2.0.4.
When tried with analytical function it worked.
select cnt from
(
select count(*) ( partition by a.col1) cnt
from order_tbl@DBLINK.PROD.NIC.CMS a
)
where cnt >1
Regards
Ved
|
|
|
|
| Re: ORA-02063: preceding line from [message #523262 is a reply to message #523240] |
Fri, 16 September 2011 08:09 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Its_me_ved wrote on Fri, 16 September 2011 07:09
My apologies!! Due to some restrictions I am unable to provide the test case in the database 10.2.0.4.
Why, are some of the keys on your keyboard locked or missing? Do you know what a test case is?
|
|
|
|
| Re: ORA-02063: preceding line from [message #523279 is a reply to message #523262] |
Fri, 16 September 2011 08:35 |
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
|
Senior Member |
|
|
Michel/Robert,
I found that the problem occured in PLSQL Developer tool. I used SQL plus and its working fine.Thanks for giving your time!
@joy_division,
Again, I would say due to some restrictions..hope you understand:)
Regards,
Ved
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
