Recent content by Jeff Kish

Well I have that but it isn't clear without a tnsnames.ora file how to proceed with it. The instructions I saw said to unzip the instant client into a subdirectory of the install of PL/SQL Developer, however then it mentioned setting enviornmental variables to the 64 bit client tnsnames.ora file...

Hi. I saw the post where you install instant client from oracle and set some environmentals to the 64 bit tnsnames.ora, but I don't have any oracle on my pc at all. I do connect to an oracle that is on a VM successfully using Oracle Sql Developer (jdbc I assume), but of course PL/SQL Developer...

Hi. I login to pl/sql and test my one line procedure: execute immediate 'create or replace view JTK as select * from myschema.asset'; I get insufficient privileges. I contact the dba and get the privileges. I get the same error. If I stay in my current session and do a 'new' sql window, and...

OK I guess I figured it out? my dos box was in administrator mode. I can run but it has to be in administrator mode. I can deal with this though I don't know if it is normal. regards Jeff

This is mildly interesting. I can login if I go to C:\oracle\product\10.2.0\db_1\BIN and enter "C:\Program Files\PLSQLDeveloper\plsqldev.exe"

I ripped Oracle off my pc and did a complete new install of 10.2.0.1. The old stuff is out of the registry (yeah I had to manually do it since the standalone deinstaler from Oracle and the 'deinstall products' was not working. If I go to this directory I can login to sqlplus and sqlplusw just...

That i interesting since sql*plus and sql developer both work, as well as the normal Oracle utilties. Are you suggesting I reinstall the Oracle client? thanks much! Jeff

Hi Marco. No luck yet.I got this messagebox when I restarted. PL/SQL Developer Initialization error Could not initialize "c:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll" Make sure you have the 32 bits Oracle Client installed. OCIDLL forced to C:\app\jeffk\product\11.2.0\dbhome_1\BIN\oci.dll...

Hi. I can login from here: C:\app\jeffk\product\11.2.0\dbhome_1\BIN> but not these places: C:\app\jeffk\product\11.2.0\client_1\bin C:\app\jeffk\product\11.2.0\client_2\bin

I reinstalled into c:\program files\sqldeveloper but I"m getting ORA-12560: TNS:protocol adapter error. I can run sqldeveloper just fine (but don't want to ;> ) ) Thanks for any hints. Jeff

Hi. I have been trying to figure this out for a while, but keep getting pulled off. I have windows 7 64 bit, and pl/sql developer 8 installed. At the very bottom of this post is my information from oracle info. When I try to connect I tgeht ora-12154: TNS:could not resolve the conect...

thanks Scott. I have not familiarized myself with this before. Jeff

Hi. I'm trying to log some information in a transaction that fails (no commit...). It is alot and I was wondering if there is an alternative to using the dbms_output.putline as there is a 1M limit to output. thanks Jeff

yes, I can

Hi. I can't quite seem to get the data generator to work for the 'master' feature. Can someone tell me what I'm doing wrong? I did the following: choose myobjects in browser window on left activate data generator via menu There are three fields. The third one is one I'd like to populate using...