How do I show the Functions/Procedures within a Package
I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures
"Go to definition" jumps to the package specification, not the package body, like a shift+F12
Hi. Thank you for last update DBForge studio for Oracle to 6.0.85. Great job. Fixed many bugs. But at the same time a new problem appeared - "Go to definition" (F12) makes jump to package spec. (like a shift+F12) rather then to package body, . Reloading
KeyNotFoundException when using Oracle spatial functions in EF Core 8
Hello, We are in the middle of upgrading EF Core 6 to EF Core 8 along with upgrading from .NET 6 to .NET 8. We found and reported an issue when analyzing this upgrade. That issue is here: https://support.devart.com/portal/en/community/topic/unexpected-sqlparameterexpression-implementation-when-using-oracle-spatial-functions-in-ef-core-8
magic disappearing Data Viewer window
after jumping from Find and Replace window to Data viewer (mouse click) it magic disappear (get empty) dbForge studio for Oracle 6.0.85
Devart.Data.Oracle "PInvokeStackImbalance" error in debug mode
I created the following small C# program and keep getting the error message shown in the screenshot. I'm using Visual Studio 2019. The program is compiled as 32-bit. The Oracle client = NT_193000_client. I've also tried oracle client 11.2.0 but the same
Version Control on Script Files for Oracle
Other Devart Tools allow for Source Control on Script Files but not for Oracle? Also there is no Schema Compare to Script Files, this is a major missing component. This allows Redgate to monopolize the market and charge $140,000.00 for a 50 user Enterprise
Oracle - EFCore - Hints
Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?
dbforge studio4oracle problem restoring windows/toolbars layout after restart app
Hi. reproducing case: 1. make any changes in windows/toolbars layout what differ from default, 2. place and pin find and replace dialog as on image 3. restart app windows and toolbar layout will be reset to default dbforge studio4 oracle v 2025.1.134
connection "forgot" parameter "enable DBMS output"
Hi, after automatic reconnection connection "forgot" parameter "enable DBMS output". dbforge studio for oracle 2025.1.34
exec current statement for pl/sql bloc containing JSON_OBJECT cause error
hi, running this block via execute current statement cause error 1 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier> The symbol ";" was substituted for "end-of-file"
How to compile a db object loaded from a file?
I can't find any documentation on how to use DB Forge Studio for Oracle to load a package spec and body from a file on my PC and then compile it. It only seems possible to create them from scratch or to edit existing objects. My team keeps all of our
scroll problem in table editor
hi, as for me something wrong with panel scrolling in table editor also good place for field comment is main column list rather column property. It's only my opinion of course. Thank you
The keyword "then" causes inserting ifthen snippet
Hi, "then" keyword causes to inserting "ifthen" snippet dbforge for oracle 6.0.85
no prompts for package procedure parameters
dbforge for oracle 6.0.85 and prev
memory !!
Hi, dbborge for oracle 6.0.85 something wrong with memory consumption and this is not related to large dataset suddenly dbforge was freezing for some minutes and i needed to kill process i have catched same case two times , previous version dbforge have
no possibility to reset check box "not null" in table editor
Hi,scenario: 1 open table editor - ok 2 add new field - ok 3 set "not null" check box - ok 4 jump to another field - ok 5 return to my new field - ok 6 try to reset "not null" check box - ok 7 jump to another field - fiasco - "not null" check box return
document outline break down
this line break down document outline dbforge for oracle 6.0.85
ORA-00918: column ambiguously defined for paging mode (
hi, i got error while getting next page of query result. for first page i have warning - it's Ok. but for next page i have ERROR 1 ORA-00918: column ambiguously defined SQL3.sql 3 8 Yes, i really have repeating column names, but without paging or for
header of tab sometimes not in visible position !!!
Hi, sometimes the tab header is not in visible position after opening new tab and need to scroll tabs for finding it.
Metadata Caching and Refresh When Closing dbforge Application
Is there any ability / options to cache and restore database metadata when an instance of the dbforge application is closed and re-opened? Our primary Oracle database has thousands of objects across dozens of schemas, and it takes a long time for the
Where can I view Java Classes in dbforge Studio for Oracle Database Explorer?
I can easily expand and select Java classes to view the source code in Oracle SQL Developer. But, how to do it in dbforge Studio for Oracle?
How to properly sync sequence values from production to development?
I synchronize the Oracle Database 12c R2 from production to development weekly. However, I am encountering a problem where the current sequence values from production cannot be synchronized to the development instance. Is there an option in the wizard
Debugger failed with timeout
hi. I have problem with "step into" while debug code : "Debugger failed with timeout" What's wrong ? Thank you.
code completion for procedure parameters
Hi. code completion for procedure parameters don't work ( dbForge Studio 2024 for Oracle v. 4.6.15 refresh suggestions, ctrl+space does not help also sometimes in some sessions code completions stops working completely ( Thank you.
what grants required for "Navigate to definition" ?
Hi, i have had error while trying to "Navigate to definition" what grants required for "Navigate to definition" ? and are they necessary ? Another IDE successfully perform operation like this under the same user . You should understand that not all users
Strange behavior when opening and saving documents to OneDrive
I have dbForge Studio 2022 for Oracle PE v4.4.64. At my work, I save all my work in OneDrive. For years I have become used to a behavior where, a few seconds after saving a file, I am prompted like this: I assume some file properties were in motion while
Code debuging
Hi, where is debug menu items ? Thank you.
Find and replace dialog - look in All open documents
Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.
current_schema ?
Hi, how to set current_schema ? Yes, i can make it using ALTER SESSION SET CURRENT_SCHEMA = but 1. It's not convenient 2. In database explorer tree view staying old schema I think this feature should be integrated in interface.
where is trigger tab in table editor window ????
Hi where is trigger tab in table editor window ???? i see columns, constraints, Indexes, Options, Date but, triggers ???? Is it exists only in Database explorer tree ?
where is window splitting for procedures and package window ?????
where is window splitting for procedures and package editor window ????? is this possibility a big technical problem ?
Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.
Hi Team! I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection. The problem seems relates to the fact that query: SELECT * FROM ALL_OBJECTS WHERE OWNER = 'MY_SCHEME'
How to ignore INITRANS with Oracle Schema Compare?
I'm comparing an 11.2 database to a 19.0 database. In the comparison view, this is the 11.2 db: and this is the 19.0 db: And this is the relevant part of the sync script: How can I eliminate INITRANS from the comparison?
Data Comparison. Describe Objects
I have two databases with each schema containing 171,000 tables(Since it is an ERP application). I want to compare a select few tables only, but first I need to load all the objects. Steps performed: 1. select New data comparison option 2. Select source
dbForge for Oracle
Discussion of open issues, suggestions, and bugs regarding database management and development tools for Oracle