Recent content by Morff

Sorry Marco Of course it works .. But I forgot to take a grant on dba_source to user :) Thanks a lot

I thought so , but in 13.0.0.1883 (32 bit) is not. The query is still from all_source.

I found that there is a bug in Oracle12c with all_source view. But dba_source view is good. Is there a place to change that query manually in program ? I check that "use DBA views if available" not replaces all_source with dba_source.

Hi I'm using PLSQL ver13 in Oracle 12c and editing is very slow (auto completing in sql/command windows too). I found that program periodically executes the query: select text from sys.all_source where owner = :owner and name = :name and type = :type and origin_con_id in...

I thought it can be: OracleDataSet.sql.append(memo1.text); // oracledataset.RetrieveVariables or oracledataset.Parse or something like that if OracleDataSet.Variables.count > 0 then // Show value list editor with variables but FindVariables can help Thanks a lot.

Hi In variables editor there is a "Scan SQL" button which fills variables collection from sql command. I need create variables automatically after append sql command to oracledataset. How can I do that.

Yes , you're right .. Script is work but (as you wrote): "If the type is 'session' the output goes elsewhere" I ran : begin mypackage.myprocedure; dbms_output.put_line('Done ...'); end; / and it works :) .. but with no message ..

So I try to do this .. but it isn't work : Menu Tools -> Configure tools and 1.ctrl+insert to add item 2.on the "general" tab : description - "My script" type - session executable/script - c:\program files\plsqldeveloper\scripts\my_script.sql 3.on the "button" tab : check toolbar button...

I think about new toolbar (with "my scripts" title or something like that) or new menu item from tools menu where I can add my favorite scripts . Sometimes I need run very important script but I cannot remember where it is ;) .. I've got 1000 scripts and sometimes I'm blind ;) .. I think it...

when I press the "Compile invalid object" button I've got an error 'Class TSavedialog not found'

Helo I've got two questions : 1.How about line numbers (on the gutter or something) in command window ? Now , if I want locate error I must copy script to external editor and find mistake .. 2. Is here something like "wishlist" ? Regards Morff

thanks a lot Regards Morff

I've problem when I import tables by PL/SQL Developer import from .pdc file .. After open , import is pending , but when I try open Log tab , application hangs. ver is 7.1.1.1339