Recent content by Michael McAuley

Yes, you can see the errors from sqlplus Command window in developer SQL> alter package tx_certificate_pk compile debug body; Warning: Package body altered with compilation errors SQL> show errors; No errors SQLPLUS SQL> alter package tx_certificate_pk compile debug body; Warning: Package...

The program window will not show wrapped code. If it did this would be a workable solution. Thanks for the reply though...

Hi, I compile a package body, and its says errors have occured. I then say show errors and the reply is "no errors". This works in sqlplus... why not the command window? Is this a bug? Is there a workaround? I'm not sure if it matters but the packages are wrapped. SQL> alter package...

The Compare user objects only has tables, views, functions etc. Is there any way to make the grants and roles and users compare?

Hi, Is there any way to generate a change script that looks at the users and roles of a source and target database? I would love :p that functionality....

I think i figured it out. It must be the button that looks like a cylinder and a disk, underneath the prev/next arrow buttons.

where is this button? Are you refering to the right click on grid --> export button? If so - that only gets the data that is currently on screen i.e. brought back by the query.

Hi, I would like to be able to export tables in csv or ~ values. I experience out of memory problem when I try to view to contents of the entire table. The table has apprx 1.5 million rows. Can this be done without viewing the tables?