Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
LOAD*;
SQL SELECT YEAR
FROM TABLE ( SC1.pkg1.get_period@dblink1(2) );
We have already created and tested dblink between two database. select * from table1@@dblink1 is working fine. we are getting below error while running package with single argument as number passed from dblink.
Hi @Tool_Tip ,
I think the format doesn't work with Qlik. Try the classic synthax like this :
<server>.<database>.<schema>.<table>
For example : DatabaseServer1.db1.dbo.table1
Regards.
Insert a blank space between "LOAD" and "*" like this: LOAD *;
Not working
Try removing "Load *;" completely, it's not necessary. But add a table name for the resulting table, like this:
[loadedTable:]
SQL SELECT YEAR
FROM TABLE ( SC1.pkg1.get_period@dblink1(2) );
If it still doesn't work, try the sql statement in a sql client (not inside qlik) directly against the database. If the query works there, maybe Qlik has a problem with the (kind of strange) table name you are trying to select from. I don't recall exactly how the sql syntax is in oracle, but maybe you could add something like ` ... ` around the table name?
Hi,
just try to create a new DB Connection to the instance from the dblink in Qlik Sense instead of using a dblink over Qlik Sense.
KR
It's not a Qlik issue because Qlik doesn't execute any sql else transferred only the statement per driver to the data-base and get the return on the same way back.
Assuming that your data-bases are appropriate configured to support dblink it's likely that the driver doesn't - in general or missing some configurations or needing a specific syntax. I think looking on the help-sites/communities from the data-base/driver should give valuable hints.