Problems with dblink and curso

[Augusto Sabino]

I am executing the following function call via dblink in an SQL statement within a cursor: pi.pte_get_value@prd_folrmse (cCompany, date, variable_code, '01 ',' XXXX ',' M '). But it returns no rows. I have already tested the same statement with SQLDeveloper and the problem does not occur and returns 71 rows.

Has anyone been through something similar?

Thank's.

 

[Marco Kalter]

Can you send me a screenshot of the window where you execute this call, and a screenshot of the missing or empty result set?

 

[SaKa]

Hi Augusto,
I have used DbLinks few times and never seen such an issue in PLSQLD.

One thing to check is, I often make mistakes when using different applications, as SQLDeveloper uses different types of connections, i have in the past accidentally connected to Test database in one app and Pilot database in another. Also different user logins may have filtering on data as well so you used same user on both?

Have you tried with SQL Plus?
Cheers.
Sak