Recent content by soldado

How do I load a JSON file into an oracle table via PL/SQL Developer. I am on version 10.0.5.1710

Marco, Have you guys found a solution to this problem? I amd getting the same error in PL/SQL Dev version 7.1.1.1339. I'm running the same query: select t.table_name, cursor (select c.column_name from user_tab_cols c where c.table_name = t.table_name) as columns from user_tables t where...

I get the error message "Insufficient Priveleges" when executing an explain plan. I checked and the schema that the plan table is created on has granted the select privelage to the schema that I am running the explain plan from. What privelages do I need to excecute an explain plan via PL/SQL...

I'm using version 7.0. I would like to change my configurations so that when I press F5 to generate an explain plan to point to a different table instead of the traditional plan_table. I created another table with the same structure but different name.

The seeting between my preferences and the original setting are the same. See below. 1. Program Window > Background compilation. UNCHECKED 2. Program Window > Safe compilation. UNCHECKED 3. Connection > Session mode. EMPTY 4. Connection > Oracle Home (or OCI Library). EMPTY

I added my preferences and the problem returned. I was unable to compile packages either way. The infamous ORA-0314: not connected to Oracle returned. Replaced the original preferences that come when you first install the application and i was once again able to compile my packages. However...

I finally got it to compile. These are the steps that I took to get it to compile: 1. Backed up the preferences directory. 2. Uninstalled PL/SQL Developer. 3. Deleted the PL/SQL DEveloper folder under the Program Files directory. 4. Re-installed PL/SQL Developer. 5. Modified the...

Myd database version is 9.2.0.5 I tried unchecking the Preferences/Debugger/Add Debug information but still no luck. Not sure what's going on. I emailed support already. JTO, Try right clicking on the package body and selecting add debug information. It used to work for me on previous releases.

I am having problems compiling my packages in the program file editor. When i try to compile a package i get the ORA-0314 not connected to Oracle error. I am able to successfully compile the same package using the command file editor. Not sure what's going on ? Have any of you run into this...