You will no longer receive e-mail notifications from this forum.
Log-In to post
My laptop is Windows 8.1 Pro -64 bits. I would like to install TOAD to connect Oracle 11g (Apps DB).
Please advice which version of TOAD we should install.
Thanks for your timing and helping me.
Hi, I am trying to use BULK COLLECT INTO with LIMIT clause in a stored procedure. I am using a cursor to get data (500k rows) from a remote database (a table in Teradata), then insert these records to a table in Oracle. After I run the procedure, the table in Oracle only has 1000 rows. Just wondering why not all the 500k rows were being inserted. Here is what the code looks like:
CREATE OR REPLACE PROCEDURE P_TEST
v_msg_proc_name varchar2(30) := ‘P_TEST’;
-- Create a record set for bulk insert
from a table in Teradata@dblink a -- a table in Teradata that has 500k rows and 50 columns
TYPE c_test_table IS TABLE OF c_test_rec%ROWTYPE;
c_test_table_ins c_test_table := c_test_table();
EXECUTE IMMEDIATE 'TRUNCATE TABLE TEST';
BULK COLLECT INTO c_test_table_ins LIMIT 1000;
EXIT WHEN c_test_table_ins.COUNT = 0;
FORALL i IN 1 .. c_test_table_ins.COUNT
INSERT /*+ APPEND_VALUES */ INTO test VALUES c_test_table_ins(i);
WHEN OTHERS THEN
g_err_code := SQLCODE;
g_err_msg := substr(SQLERRM, 1, 200);
g_err_msg_log := g_err_msg_log || v_msg_proc_name || ': ' || g_err_code ||' - ' || g_err_msg || chr(13);
I have a query that gives me correct answer but I can't figure out how to get percentage. What I have tried so far is as follows:
select SHRTCKN_CRN CRN, count (distinct (SHRTCKN_PIDM)) PIDM, SHRTCKG_GRDE_CODE_FINAL GR
/*round((((count(SHRTCKG_GRDE_CODE_FINAL))/count (distinct (SHRTCKN_PIDM)))*100), 2) Perc*/
from SHRTCKN, SHRTCKG
where SHRTCKN_TERM_CODE =: p_termand SHRTCKN_PIDM = SHRTCKG_PIDMand SHRTCKN_TERM_CODE = SHRTCKG_TERM_CODEand SHRTCKN_SEQ_NO = SHRTCKG_TCKN_SEQ_NOand SHRTCKG_GRDE_CODE_FINAL in ('A', 'B+', 'B', 'C+', 'C', 'D+', 'D', 'F', 'FA', 'GR', 'W', 'WF', 'I')group by SHRTCKN_CRN, SHRTCKG_GRDE_CODE_FINAL
Result of my query is as follows:
CRN PIDM GR
20001 4 A20001 4 B20001 4 B+20001 2 C20001 7 C+20001 7 D20001 2 D+20001 3 F20002 8 A20002 14 B20002 11 B+20002 2 C20002 7 C+20002 2 D+20002 1 W
I am trying to find percentage of GR per CRN i.e count of PIDM per GR per CRN divided by total count of PIDM per CRN. As you will notice from the commented area of my select statement, my attempts have not been successful.
Any assistance provided would be appreciated.
I encountered this error this morning and found the following info helpful (original post found here: http://www.easywebtech.com/oracle_ORA-12638.html):
ORA-12638: Credential retrieval failed
If you get this error first you need to check the SQLNET.ORA file. This file is located in [Oracle_Home]/NETWORK/ADMIN/SQLNET.ORA
if you see SQLNET.AUTHENTICATION_SERVICES= (NTS)
this needs to change to SQLNET.AUTHENTICATION_SERVICES= (NONE)
after that try to login to the database
Hi I am trying to create a sql script that inserts data from a staging table to the main table and in the staging table I have a column called datetime that is a varchar field.
I am inserting all columns plus converting the datetime field to the field in the main table that has a datatype of time stamp.
Data in im DateTime staging table looks like this.
'10-JUN-16 12:00 AM'
I tried this below and it didn't work. I got an error message saying. a non-numeric character was found where numeric was expected. My assumption is the AM is or the JUN is throwing it off.
INSERT INTO meterdatarows SELECT 'HardCodedField', meterid, TO_TIMESTAMP (datetime, 'yyyy/mm/dd hh24:mi:ss'), value FROM meterdatarowsstaging commit;
Thanks for the help.
Since 2 days when I am exporting the result of a query to excel 2007, I am receiving this error message
"toad error tag stack not empty worksheet sheetdata row c"
There is about 120 000 rows. Sometimes It works perfect sometime no.
Can any body help?
TOAD FOR ORACLE 126.96.36.199
Is there any pre existing table for Mapping of US States with the two character State ID?
I am parsing user entry for US states and would like to get the two character State ID.
Are there any recommendations?
I am a new user of Toad.
I created a package then was able to compile and run it.
When it came to trying some changes, these changes were not saved successfully.
Next I deleted the package and tried to create a new package and I got the Warning"
"Package Body does not exist or you do not have the necessary privilege to access it"
If this is a privilege issue?
Any help will be appreciated. Let me know if I need to give more information.
I have not been able to set up a team coding project using a third party VCS. I have tried with SVN TortoiseSVN and Git. I get to the same place. After successfully configuring everything up to clicking the OK button on the Create Team Project window I get the same log message: hh:mm:ss Output: VCS Provider is not set. I am running Toad 188.8.131.52 Xpert Edition, Toad Development Suite for Oracle. My Git for Windows is v2.8.1. Any help would be much appreciated.
Currently we have an application in which under certain conditions you are not able to change the Oracle password due to limitations created by the developer of the application.
We are discussing with the developer to change that, but that will take some time, because we are on an older version and don't want to upgrade on this moment.
My question is now, has someone ever created a website/webservice, so that users can change their password?
I use a dark background as my default in TOAD, but this seems to cause problems with Script Output / Output tab. Unless I am missing something, there seems to be no way to change the text colour to anything but black, which makes the output unreadable. See below (see image). Can you add an option somewhere please?
How can I import multiple data tables from an access database at once in toad oracle.
Right now I have a query that I run that drops yesterdays tables and then I create new tables. Then I go into import, table data and I have to select each table from my database manually. This is time consuming, is there anyway to import all tables at once? Thanks
Trying to make the big step from 9.7 to 12. I installed the trial and wanted to test it in a real situation. But without knowing what I'm doing wrong I get frequently an access violation. For the old version I have a oracle 32bits client installed. But I've also a 64bits client installed. Do I have a kind of conflict? Is it better to install 32bits of Toad? Is there a checklist with possible causes and/or solutions.
As subject, I'd like to know if it's possible to build subfolder under View to differentiate from current views? I don't see a simple way to do that in SQL Developer, wonder if Toad for Oracle can offer the feature. Thanks very much!
Hi, thought that may be useful for some...
Oracle Forms and Oracle EBS on Chrome is still alive - with SSO, Cookie and JS, and no NPAPI needed
> Chrome Extension for Oracle Forms and Oracle EBS - NPAPI-less
That will shake things up :)
My task is to excute a custom sql and export the result to excel . I have toad for oracleI have followed:
I have wen to automated designer and right clicked on Action and said schedule and scheduled for a time, it is showing up in Scheduled items , but task will not excute , Can some one tell me Do I need to do anything else.?
A user with "select any dictionary", "select any table" and "select_catalog" role is not able to view the procedure created under other user.
What else does the user need in order to view procedure source code belongs to other user?
Thanks in advance,
Toad - 184.108.40.206 (Licensed version)
Oracle Server - 220.127.116.11.0
Oracle Client - 18.104.22.168.0
OS - Windows 7 Professional - Service Pack 1
My Toad was working perfectly till last week. All of sudden starting this week, Every thing gets hanged and gives result after 30 to 40 Secs . Even executing 'Select sysdate from dual' gives result after 30 Secs. But I am able to connect to Oracle server using SQL+ and SQL Developer without any issues and execute all the queries. As soon as i hit F9, it just hangs for 30 Secs.
I tried re-installing Toad with no luck.
Any help much appreciated.
Assume we have a service with preferred node as 1 and available node as 2.
We are shutting down the instance 1 manually what will happen to the service? Will it failover to available node?
No it won’t and if we query the status of the service it will report that it is not running.
Always we have to relocate service if it is running on single node. More than one node no issues.
In 11.2, you need to specify -f option if you want service failover (start in another instance)) to available instance (ie, srvctl stop instance -d xxx -i xxx1 -f) when stopping instance using srvctl and the service is running on only one node.
We are killing pmon for a instance to test or node eviction happens due to contention or high memory swapping and node 1 evicts. What will happen to the service? Will it failover?
Yes service failover happens only when the instance or node evicts based on the service configuration. Always ensure service is configured in more than one node.
While creating a service it creates the service as below
Management policy: AUTOMATIC which means it will start the service when it comes up if we stop and start the instance manually.
we have a service which is running on both the nodes as preferred. When I bring down the instance 1 service will run on node 2. After patching or node eviction if we bring up the instance or node 1 up the service will start running on both the nodes 1 & 2.
Any suggestion or corrections to this post are welcome.
Also would like to know how cluster decides whether to fail over or to start back a service? where can i get more readings on this?