Query via dblink is giving error ORA-02022

Asked

Viewed 20 times

-1

Good evening, I am making a query by PL/SQL in a postgres database, connected by a dblink, in postgres the view is executed correctly, but when I consult through dbllink is giving the error ORA-02022. Someone knows what I must do to fix this?

postgresql pl-sql

  • Please clarify your problem or provide additional details in order to highlight exactly what you need. The way it’s written these days it’s hard to tell exactly what you’re asking.

  • The doc says "Remote statement has unoptimized view with remote Object" passed sql in parsing in Postgresql ? But the way the only psychic question to know how to answer.

  • In case I created a view in postgres and I am trying to query it in pl/sql through dblink and is giving this error, in pgadmin ran normal.

1 answer

0

I thank those who tried to help. I was able to identify the problem. There was a column with very large values and it was causing the problem.

Browser other questions tagged postgresql pl-sql

You are not signed in. Login or sign up in order to post.