Recent content by Jeevan

  1. J

    ORA-01008: not all variables bound ... in pl/sql developer 10.0.2.1697

    Thanks Roeland, BTW, found another way, In a SQL Window, itself, edit the query and use '&' instead of ':' select t.*, t.rowid from minf t where t.p_mid = ∣ When the SQL is executed (F8 or Ctrl+F8) a window pops up, asking for values for place holder. thanks Jeevan
  2. J

    ORA-01008: not all variables bound ... in pl/sql developer 10.0.2.1697

    Hi, I am using pl sql developer 10.0.2.1697. and in sql window, I have a query which uses placeholders select t.*, t.rowid from minf t where t.p_mid = :MID; How to use such queries in pl sql developer? My colleagues are suggesting - switch Oracle SQL Developer, which prompts user for...
  3. J

    cannot launch PL/SQL dev ... ORA 12154...Could not resolve TNS name

    found the culprit.... it was due to "oracle bug 3807408" as PL/SQL dev was installed under c:\Program Files (x86)\PLSQL.... I moved it to another folder without the "(x86)" and it worked.
  4. J

    cannot launch PL/SQL dev ... ORA 12154...Could not resolve TNS name

    also adding, I am using Windows 2000 Server, 64 bit
  5. J

    cannot launch PL/SQL dev ... ORA 12154...Could not resolve TNS name

    Hi, PL/ SQL dev has been my preferred tool, when working with Oracle. On my new box, I installed PL/SQL developer 7.1.5.1398 but cannot log into my database with it. It gives me a ORA 12154 : TNS Could not resolve name, error But on the same box, I can use (SQL net) SQL PlusW, to connect to...
See more
Back
Top