Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,562 Comments
Recently i have a minor issue when navigating bookmarks within package body. whenever i press strg+q and there is no bookmark after the actual position, some seconds later an error message pops up “Bei der Ausführung des angeforderten Vorgangs ist ein Fehler aufgetreten:
I/O-Fehler: Unknown host specified
Herstellercode 17002”
i have press 2 or 3 times “OK”. Then an new empty tab opens, titled with the name of the package body.
sqldev version Version 4.1.3.20
I am getting ORA-01460 errors trying to view object in a 9i database from SQL Developer 4.1.1
Is there a fi or workaround for this?
upgrade your database or downgrade your SQLDev
sqldev is using a 12c jdbc driver to talk to a 15 year old database
Obviously I will need to downgrade SQL Dev. Who among us can simply upgrade the dAatabases we work on at will?
In trying ti]o get SQL Dev 4.1.1 to run with a 9i client, I went to Tools>Preferences>Database>Advanced and set a value for “Use Instant Client” using the configure button. Now I cannot clear that value, and nothing is working now. ORA-01460 errors everywhere. There appears to be no way to clear this value. Clearing the checkbox has no effect.
Can you point me to the config file so I can clear this preference setting>
Um, not a 9i client. That’s not going to work. You need to get an 11.2.0.3 or 11.2.0.4 client.
I know you can’t simply upgrade your database, but that would fix the issue. And many others that are probably hanging around…but, yeah.
I see that isn’t going to work. But I’m asking now how to UNDO the Preference change that I made to test this. The UI won’t permit me to clear this setting (it was empty before I started).
You can’t clear it, but can you uncheck the 2 ‘use’ boxes? Or can you use the dialog to point to another client?
If that all fails, rename your system4.1.X.X… directory.
Clearing the checkboxes has no effect. I’ll look at the directory you mentioned. I was hoping I could edit the config file where this is stored.
Hi Jeff, Thanks for your posts.
I use SQL Developer daily and I recently upgraded to 413 (from 4119). In both versions I had lost the breadcrumbs in the PL/SQL editor. The preference Display->Show Breadcrumbs is checked. A couple of my co- workers have the same problem too.
What can I do to bring the Breadcrumbs back ?
Thank you
– Neelesh
Hi Jeff,
I use SQL Developer every day as a DBA for the last several years – it’s great and become better and better with every release. But there are some absent things, which I dream about, like search within connections list (I have hundreeds of them, so folders are not helping much) or some modifications with text, which I’d like to bind to shortcut keys.
As I see, SQL Developer tend to be developed for the Data Modeling and 12c features and Cloud features, but not the features I particalarily need for my day-to-day job, so, I’d like to develop all this stuff myself.
When I try to find any info about plugins development, I faced a great problem – there is only bunch of broken links and very few very old articles: about 5-7 years old.
So, my question is – where should I start to look for info? Is there any ‘Oracle SQL Developer plugina development portal’, or may be some book?
Thank you!
Regards,
Andrey
Eventually we hope to but a new SDK and examples up on our Github project. But for today, it’s what’s out there plus the SQLDev and JDEv OTN communities where you can post questions or ask for help.
Hi Jeff,
Any ideas on how to extract the DDLs for ROLES and GRANTS given for specific set of users using SQL DEVELOPER?
Please help!.
Regards.
For a set of users? No. For a single user, you can use this trick.
Wow!! Thanks Jeff. It works. 🙂
Trying to import a txt file into a table and get a message that file cannot be opened due to the following error: null. If I save the file as an Excel file, the data loads fine. This happened on 4.1.2 and the current version.
save it as a .csv or a .dsv – we don’t support .txt files
Great tool! I am using this more and more, and I love that I can spool my output, just like the old SQL*Plus.
With the latest build (sqlcl-4.2.0.15.349.0706-no-jre.zip ) sql.exe is flagged by my anti-virus WebRoot for a “W32.Aware.Gen” alert. I reverted back to sqlcl-4.2.0.15.296.0549-no-jre.zip and had no problem.
Do you have any recommendations?
Thank you! Please keep up the great work.
-Ted
Is there a way to get the nice round pig’s ear for self-relationship like we could in Designer?
Also is there a way to fix relationship lines once positioned differently from the default so that the line does not cross an entity?
Regards
you mean an Arc – I never used Designer.
and yes
Not the Arc when you want the either/or scenario
I have entity where I have Parent_id and Record_Id so I want to show a self-join relationship meaning a record may have a parent record in the same table — Employee and Manager scenario. Currently this kind of relationship shows a a series of straight lines to make up a ” circle”
Does this help? Add elbows as necessary
Hi Jeff,
I have loaded over a million records (stored as a CSV) into a clob in my database, when trying to unpack this though it is taking 10 mins to do so. The file is likely to grow to 10 mil records over time and, at my projections, will take +- 50 mins to unpack and convert into a table.
Is there a way to quick retrieve the CSV data from the CLOB and convert it into a table?
Thanks,
Warren
So you’re using a table to store a clob to store 10,000,000 records – why? if you want fast access, store the 10M records as records in a table. There probably are faster ways to get the data out, but I would go ask the storage/compression/OS folks that specialize in this. All I can say is, don’t do that.
Hi Jeff,
I am trying to run a query on sql developer, I have all the connections set up and it works fine. But when I try to run the query it says either Protocol Violation [67] or no more data to read from socket or some numbers like 20300070000.
I tried to google the solution and it says something related to java, but could not find an accurate solution to it.
Can you please help?
Thanks,
Hetal
I would need a lot more info. Versions of everything, etc. In the meantime, I would open a Service Request with My Oracle Support if you have an account/
I’ve not personally seen this behavior before.
Found out about SDSQL command-line client. Interesting!
Is there any way to connect SDSQL to MS SQL, which is supported in SQL Developer?
My use case is automating some SQL scripts that do CSV exports. We found out that SQLDeveloper is the best tool for exporting CSVs.
I was thinking about automating those scripts via SQL*Plus first, but I don’t know if there is any way to connect to MS SQL from SQL*Plus.
So we’re Oracle.
MS SQL is Microsoft.
We don’t spend much time worrying about SQL Server – unless it’s to help you migrate it to Oracle.
So short answer to your question would be, ‘no.’
We care about you, just not so little that we would encourage you to stay on MSFT’s database 😉
Hi, I’m unable to delete the sql developer folder in the roaming profile folder. SOme process is Always recreatin new folders. dropin…. any idea?
Some process – that would be SQLDev. Is this on a shared/networked machine?
Yes, but can’t find any process.
a program is using that dir/file, so windows won’t let go of it
you have to find the process and kill it
if you can’t find it, i would try rebooting the box – this isn’t really a SQLDev question though, it’s more about Windows
I am getting a “Invalid column name ‘suid’. Vendor code 207” error when I try to access SQL Server 2014 databases from SQL Developer. I do not have a problem accessing 2008 R2 databases. The databases are visible , but when attempt to drill down to the tables I get the error. Is there a fix for this problem? Your help is appreciated.
Hello I’m having the same issue for the same versions of the various softwares (SQL Developer, SQL Server and JTDS).
Any solution for this or any clue on what is the origin of the problem?
Hello Jeff,
Could you please explain why SQLdeveloper does a SVN delete –force?
I edited a database copy of a package, tried file save as, the file was already open in SQLdeveloper, I closed it and saved the database copy using the same name. The file was no longer under version control.
Thank you,
Ruben.
Hi Jeff!
We are embarking on a BI project using Oracle Data Integrator (ODI). There is an official recommendation for ODI to have all the tables in one schema. We are planing to have 1000+ tables. Such big schemas obviously put a strain on the developer as looking up for a specific table becomes tiresome. We have naming standards and I know of the “just start typing” shortcut in the connections tree or schema browser window and that there is a table filter in both schema browser and connections tree window. However, I’d like to be able to switch the displayed set of tables “instantly” – to have multiple saved table filters and to switch them by a keyboard shortcut. The next best approximation would be to have multiple schema browsers (each with its own filter) – however, right now I can have only one schema browser window for a single schema. Is there any way to come close to the desired setup in current version (using 4.1.2.20), or do you have a suggestion how to be able to quickly deal with such number of tables?
Thank you very much for your time!
A few ideas come to mind. Basically, having trees that tall will never be a pleasure to work with. And even the schema browser will have limited use, as they don’t have the filter history that you are asking for.
So, my ideas – read these posts and maybe take a few bits of each:
I completely forgot about reports! I like the idea of customized actionable data dictionary reports very much! Although Jerome dismissed the “everything in one schema” approach as the only viable (and so we will probably split data “topics” each in own schema and have a much more manageable set of tables), I can think of other uses of such reports (mostly used objects grouped together and many others). Thank you for your insight!
Hi Aleksander,
Are the 1000+ tables your target tables on which you are going to do reporting or are they work tables created by the ODI Knowledge Modules?
In the first case, there is absolutely no harm to have it in different schemas. I would just recommend to use a single Data Server per database in your ODI Topology.
It is only recommended to regroup all your work tables – created by ODI – in a single schema to avoid polluting your target schemas. These tables will usually be prefixed by prefixes like C$_ for extraction, I$_ for integration, J$_ for journalization or E$_ for errors and you probably don’t want that in a clean data warehousing schema. That’s why a single work schema, usually called ODI_TEMP, is used. But if you have too many work tables, nothing prevents you to have multiple work schemas instead of just one.
In addition, most of the knowledge modules will drop C$_ and I$_ tables after a successful execution.
More about the ODI physical topology (and the work schema) here : http://www.rittmanmead.com/2014/12/data-integration-tips-one-data-server/
Hope it helps.
Best Regards,
JeromeFr
We will have around 250 “target” tables (dimensions and facts), others will be some aggregates, archives, staging and helper tables. I’ll also check out the document you suggested! Jerome, thank you for your valuable advice.
See Jerome’s answer too – he’s an Oracle ACE in the BI space and I asked him to weigh in with his advice.
Jeff, I really appreciate that you forwarded my question to Jerome. Thank you.
hi jeffsmith, can you upload a videos or photos , how to do unit testing and reporting in oracle
thanking you
unit testing or reporting, or reporting for unit tests?
unit testing , i new to this technology , im eagerly waiting to learn . i want to know how to do unit testing in oracle sqldeveloper software
and also performance tunning ! im thankful to u for making a good website , it is really useful and makes me to understand easy
I am using SQL Developer 4.1.1.19.
Executing the following query returns no records:
“SELECT MARVIN.”SAMPLE”.SAMPLE_SEQ_NO,
MARVIN.”SAMPLE”.FREQUENCY
FROM MARVIN.”SAMPLE”
WHERE MARVIN.”SAMPLE”.FREQUENCY IS NULL”
The query shows all FREQUENCY values when not set to NULL.
There are nulls in this data element and the this query shows nulls when executed in other applications. Also, nulls will show when looking at other data elements in the table. The “FREQUENCY” field is numeric and is in the last field of the table. Is the name “FREQUENCY” a problem?
Cheers,
David
sounds like more likely you don’t have nulls on the FREQUENCY column.
run a
select distinct frequency
from marvin.sample
order by 1 NULLS FIRST
and see what comes back
I just ran the query again looking at a specific record and the FREQENCY shows “1” when it’s actually “null”.
no, you think it’s NULL, it’s actually 1
Hi,
I am trying to connect oracle database via excel and it keeps giving me below error. I use SQL developer. I know this might be a question for a different forum, but still if you could help me with your expertise in this area.
error as below:
Driver’s SQLAllocHandle on SQL_HANDLE_ENV FAILED
I checked and the oracle path is set properly to the bin directory of oracle.
>>I am trying to connect oracle database via excel
Why?
Because, I want to automate the process of refreshing a certain metrics every 2 weeks so that I do not have to runt he query each time and export to excel and then create pivot tables.
before I tried that, I would create a report in APEX that refreshes the data/metric live or on-demand.
barring that, first hit on google for your error message says to check your PATH OS Environment Var and put your $ORACLE_HOME first.
Thank you Jeff. Once I changed the user account control to never it fixed the problem because when I checked the PATH it was pointing to the right directory of oracle.
I do not know what APEX is. but will take a look at it.
Thanks,
Hetal
Oracle Application Express. It’s installed in the database. Allows you to build interactive reports.
Jeff,
In Data Modeler Version 4.1.0.19, I cannot find the “View to Table Wizard” mentioned in some earlier documentation. I believe it was a new feature in SQL Dev Data Modeler 3.0? maybe?
Does this still exist? Why can’t I see it?
Thank you,
john3
Tools > Table to View Wizard
or if in SQL Dev
Tools > Data Modeler > Table to View Wizard
Thanks,
Love the blog!
john3
Hey Jeff,
I have a problem that I have been scratching my head with. I have an oracle database on my windows PC and I have the oracle sql developer setup with the database connection without any problem. Now , I have Ubunut 15.10 setup on VMware workstation player 12. Here I have setup oracle sql developer too and I am trying to connect to the database. I have looked up the listner.ora and tnsnames.ora files and the host is set to localhost and I changed it to my local host’s IP address(which I dont think would not matter since local host is my PC’s IP address, right?). So when I am trying to make a database connection on Ubuntu on Vmware. It says IOerror: Network adapter could not establish the connection. Why is this so? I am a newbie so any please spell the answer in pieces so I can understand me.
Thank You.
Step 1, can you ping the ip address from your ubuntu vm image? If not, your sqldev connection won’t work.
An easy workaround might be what we do in VirtualBox vm we ship – we setup a port forward that auto takes traffic on 1521 on the host and forwards it to the listener port on the image. You might be able to do the same, but the exact opposite, fwd the image traffic to the host port for the db listener.
I have pinged and there is a reply on the vm image
As for the second part I am not sure I understand what you said or rather how to do it(newbie here). Is there a way i could upload images here.?
i thought you said sqldev was ON the image? if so , you need to open a terminal window on the image and see if you can ping your windows host
yes the sqldev is on the image, it is and I am able to ping the host from this image. The ping replies are fine
vasisht@ubunut:~$ ping 192.168.233.1
PING 192.168.233.1 (192.168.233.1) 56(84) bytes of data
64 bytes from 192.168.233.1: icmp_seq=1 ttl=128 time=0.549ms
64 bytes from 192.168.233.1: icmp_seq=1 ttl=128 time=0.818ms
64 bytes from 192.168.233.1: icmp_seq=1 ttl=128 time=0.811ms
64 bytes from 192.168.233.1: icmp_seq=1 ttl=128 time=0.734ms
That’s what confuses me. The ping replies are fine but the database connection would not allow me to establish a connection.
the listener is setup to listen on 127/localhost and not 192.168.233.1 – that could be it
Hey ,
Thank you, I have solved the problem. It was a problem with the IP’s. I was using the wrong IP address. That’s because when I ipconfig on windows, it shows up 3 IP address. One is my localhost’s. The second and third address’s are the Virtual machine’s adapters. I was using one of those!!! Took a while for me to realize. Thanks though!!!
Hello,
Today I right clicked on a column heading in a SQL results pane. One of the options listed in the pop-up box that appeared was “Delete Persisted Settings…”. My general experience with menu items followed by an ellipses is that clicking on them results in another list of options, so I clicked it, but it executed some action immediately (I’m not even sure what it did). I think convention dictates that the ellipses should be removed from this right-click menu option since it’s not a link to additional options.
Thanks!
Dan
I would agree.
I’m trying to print certain Unicode characters like ? (http://www.fileformat.info/info/unicode/char/1f341/index.htm) in SQL Developer. I have no problem with simpler characters like †; “select UNISTR(‘\2020’) from dual” does the job. However, when I try “select UNISTR(‘\1F341’) from dual” hoping to get ?, instead I get something like “☐1”. Could you please help me to get the output I’m looking for?
By the way, when I execute “SELECT * FROM v$nls_parameters WHERE parameter LIKE ‘%CHARACTERSET'”, my result is
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
assuming the db can handle it, the next thing you have to worry about is finding a Code Editor font that will support that character
Thank you! That gave me the hint I needed:
* I changed the Code Editor font to “Segoe UI Symbol” (which I figured out from Microsoft Word can handle that character, and others that I had problems with).
* I ran “select ascii(‘?’) from dual;” to get the digital code (4036988289)
* I ran “select chr(4036988289) from dual;” to display the character I wanted.
Thanks!
Hi Jeff,
The “View Value” window seems to remember the window size but not the window position. This is a problem if the window size is big as one needs to move the window every time it is opened.
Any chance some Find functionality could be added to the window.
Regards,
Ron
Where exactly are you and what are you doing – there’s more than one feature/window that description could fall under.
Hi Jeff,
Sorry, I should have included more details in my description. I’m referring to the windows that pops up when you edit/view the contents of a cell any datagrid.
I often need to view the contents a cell that contains a clob with 1000+ lines and that is when I need to increase the size of the “View Value” window and where the Find functionality would help a lot.
Regards,
Ron
Hi Jeff
I hope you can help me!
In our company we use SQL Developer 4.1.2
When we use “desc” in the Script Output we see only
the Procedures without the Functions. In a older Version of SQL Developer Procedures and Functions were availible. Is this a Version-Problem or can we handle it in the Settings? And if we can do it in the Settings wich Parameter we need to change?
Thank you for your Help!!
Greatings Salvi
a DESC on a package?
Yeah, it’s a bug.
Workaround: use the new INFO command.
INFO
clear scrinfo sys.dbms_sql_monitor
Package
/* Package SYS.DBMS_SQL_MONITOR */
/* FUNCTION SYS.DBMS_SQL_MONITOR.BEGIN_OPERATION */
/* RETURN NUMBER */
v_ret := SYS.DBMS_SQL_MONITOR.BEGIN_OPERATION( DBOP_NAME => p_IN_param0 /* VARCHAR2 */,
DBOP_EID => p_IN_param1 /* NUMBER */,
FORCED_TRACKING => p_IN_param2 /* VARCHAR2 */,
ATTRIBUTE_LIST => p_IN_param3 /* VARCHAR2 */);
/* PROCEDURE SYS.DBMS_SQL_MONITOR.END_OPERATION */
SYS.DBMS_SQL_MONITOR.END_OPERATION( DBOP_NAME => p_IN_param0 /* VARCHAR2 */,
DBOP_EID => p_IN_param1 /* NUMBER */);
/* FUNCTION SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR */
/* RETURN CLOB */
v_ret := SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR( SQL_ID => p_IN_param0 /* VARCHAR2 */,
DBOP_NAME => p_IN_param1 /* VARCHAR2 */,
DBOP_EXEC_ID => p_IN_param2 /* NUMBER */,
SESSION_ID => p_IN_param3 /* NUMBER */,
SESSION_SERIAL => p_IN_param4 /* NUMBER */,
SQL_EXEC_START => p_IN_param5 /* DATE */,
SQL_EXEC_ID => p_IN_param6 /* NUMBER */,
INST_ID => p_IN_param7 /* NUMBER */,
START_TIME_FILTER => p_IN_param8 /* DATE */,
END_TIME_FILTER => p_IN_param9 /* DATE */,
INSTANCE_ID_FILTER => p_IN_param10 /* NUMBER */,
PARALLEL_FILTER => p_IN_param11 /* VARCHAR2 */,
PLAN_LINE_FILTER => p_IN_param12 /* NUMBER */,
EVENT_DETAIL => p_IN_param13 /* VARCHAR2 */,
BUCKET_MAX_COUNT => p_IN_param14 /* NUMBER */,
BUCKET_INTERVAL => p_IN_param15 /* NUMBER */,
BASE_PATH => p_IN_param16 /* VARCHAR2 */,
LAST_REFRESH_TIME => p_IN_param17 /* DATE */,
REPORT_LEVEL => p_IN_param18 /* VARCHAR2 */,
TYPE => p_IN_param19 /* VARCHAR2 */,
SQL_PLAN_HASH_VALUE => p_IN_param20 /* NUMBER */,
CON_NAME => p_IN_param21 /* VARCHAR2 */);
/* FUNCTION SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_XML */
/* RETURN OPAQUE/XMLTYPE */
v_ret := SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_XML( SQL_ID => p_IN_param0 /* VARCHAR2 */,
DBOP_NAME => p_IN_param1 /* VARCHAR2 */,
DBOP_EXEC_ID => p_IN_param2 /* NUMBER */,
SESSION_ID => p_IN_param3 /* NUMBER */,
SESSION_SERIAL => p_IN_param4 /* NUMBER */,
SQL_EXEC_START => p_IN_param5 /* DATE */,
SQL_EXEC_ID => p_IN_param6 /* NUMBER */,
INST_ID => p_IN_param7 /* NUMBER */,
START_TIME_FILTER => p_IN_param8 /* DATE */,
END_TIME_FILTER => p_IN_param9 /* DATE */,
INSTANCE_ID_FILTER => p_IN_param10 /* NUMBER */,
PARALLEL_FILTER => p_IN_param11 /* VARCHAR2 */,
PLAN_LINE_FILTER => p_IN_param12 /* NUMBER */,
EVENT_DETAIL => p_IN_param13 /* VARCHAR2 */,
BUCKET_MAX_COUNT => p_IN_param14 /* NUMBER */,
BUCKET_INTERVAL => p_IN_param15 /* NUMBER */,
BASE_PATH => p_IN_param16 /* VARCHAR2 */,
LAST_REFRESH_TIME => p_IN_param17 /* DATE */,
REPORT_LEVEL => p_IN_param18 /* VARCHAR2 */,
AUTO_REFRESH => p_IN_param19 /* NUMBER */,
SQL_PLAN_HASH_VALUE => p_IN_param20 /* NUMBER */,
CON_NAME => p_IN_param21 /* VARCHAR2 */);
/* FUNCTION SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_LIST */
/* RETURN CLOB */
v_ret := SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_LIST( SQL_ID => p_IN_param0 /* VARCHAR2 */,
DBOP_NAME => p_IN_param1 /* VARCHAR2 */,
MONITOR_TYPE => p_IN_param2 /* NUMBER */,
SESSION_ID => p_IN_param3 /* NUMBER */,
SESSION_SERIAL => p_IN_param4 /* NUMBER */,
INST_ID => p_IN_param5 /* NUMBER */,
ACTIVE_SINCE_DATE => p_IN_param6 /* DATE */,
ACTIVE_SINCE_SEC => p_IN_param7 /* NUMBER */,
LAST_REFRESH_TIME => p_IN_param8 /* DATE */,
REPORT_LEVEL => p_IN_param9 /* VARCHAR2 */,
AUTO_REFRESH => p_IN_param10 /* NUMBER */,
BASE_PATH => p_IN_param11 /* VARCHAR2 */,
TYPE => p_IN_param12 /* VARCHAR2 */,
CON_NAME => p_IN_param13 /* VARCHAR2 */);
/* FUNCTION SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_LIST_XML */
/* RETURN OPAQUE/XMLTYPE */
v_ret := SYS.DBMS_SQL_MONITOR.REPORT_SQL_MONITOR_LIST_XML( SQL_ID => p_IN_param0 /* VARCHAR2 */,
DBOP_NAME => p_IN_param1 /* VARCHAR2 */,
MONITOR_TYPE => p_IN_param2 /* NUMBER */,
SESSION_ID => p_IN_param3 /* NUMBER */,
SESSION_SERIAL => p_IN_param4 /* NUMBER */,
INST_ID => p_IN_param5 /* NUMBER */,
ACTIVE_SINCE_DATE => p_IN_param6 /* DATE */,
ACTIVE_SINCE_SEC => p_IN_param7 /* NUMBER */,
LAST_REFRESH_TIME => p_IN_param8 /* DATE */,
REPORT_LEVEL => p_IN_param9 /* VARCHAR2 */,
AUTO_REFRESH => p_IN_param10 /* NUMBER */,
BASE_PATH => p_IN_param11 /* VARCHAR2 */,
CON_NAME => p_IN_param12 /* VARCHAR2 */);
Hi sir
yesterday i was asking regarding the linux terminal oracle vm
i am unable to connect please see this blog for screen shots .
please suggest how to resolve io failure.
https://infoallsite.wordpress.com/
waiting !!!