I have also 2 OCI databases and ran into the same problem. What I have done is combine the tnsnames.ora files in both wallets so both tnsnames.ora files are equal and contains the same database entries.
This fixed the "ORA-12529: TNS:connect request rejected based on current filtering rules."...
Using 16.0.0.2136 the icon set on the right of the 'Define connections' window are not correct:
-New connection is a down arrow
-Delete is a + icon
-Move up is a folder list icon
-Move down is a up arrow
-Export is a delete icon
-Import is a save folder list icon
When I run the following command in a Command Window the export does not process the 'Drop' parameter:
Export Tables=TABLENAME Method="SQL Inserts" Drop DisableTriggers DisableFKs Commit="500" Filename="c:\temp\tablename.tab" Wait
See screenshot.
This also happens with the Create parameter
I...
Is it possible to save changes that I want to make to one or more fetched records in a SQL Window to a file/clipboard in update/inser/delete format for use in a command Window?
Using PL/SQL Dev 13.0.6 / Oracle 12.2 oci.dll
When doing a "query by example" on Oracle 12c the query is build as expected.
select * from MDR_ODE_EMAIL t
where ode_id = 'VN'
When doing the same "query by example" on Oracle 19c the query is showing :qbe_var1 in stead of 'VN'
select * from...
This last post from Valentino did not work for me.
I downloaded the wallet zip file, unzipped it into my default tnsnames location.
These are the files:
cwallet.sso
ewallet.p12
keystore.jks
ojdbc.properties
sqlnet.ora
tnsnames.ora
truststore.jks
Starting PL/SQL Developer and logging in gives...
Hi,
I want to update ActiveQueryBuilder to 1.4.1 (64bits) but after installing de version info of ActiveQueryBuilder keeps showing 1.26.3.0
I manualy deleted the ActiveQueryBuilder.dll and did a reinstall but that did not work.
I am using PL/SQL Dev 13 beta 9 64 bits
Regards,
Frank Huijbreghs