Recent content by Rick Wiker

How do I pass global variables into a package in the debug Test window? I have the following situation: pa_api_wo_cds_info.p_param1:= :p_param1; pa_api_wo_cds_info.add_cds_line_item( :p_user_name , :p_work_order_num , :p_req_deliv_dt); where...

It's 8 gig.

I exported a large table using SQL export. When I tried importing the file nothing would happen. After a number of tries, I switched from using the command window to using sql*plus, and the import worked fine. I using version 7.0.0.1050. Looks like a bug. Hope this helps.

We've tried with both the latest 6.? version and with 7

When I (or any other developer in our group) right clicks in an editor window, PL/SQL Developer is hanging. The only difference between today and Friday is that the san on our QA database crashed. We are all working in development on a different server, but I'm wondering if the query that...

I was referring to the export/import commands available from the tools menu. Ideally I would like to export an ascii fixed field file. I could then use SQL Loader on the receiving end. I think this is the best option for performance, although I've been wrong before :) .

Is it possible to call the plsql export/import commands from a procedure? I need to unload large amounts of data from another database and import it into my active one daily.