Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
Hi,When you choose for some table "Rebuild" option, Toad creates script.Unfortunately it does not works if a table has materialized view.Is there any way to fix that in next releases ...drop and create mat view script part for that table.BrgDamir
I am having an issue in the where clause case statement of this select. please help me out
it says 00907. 00000 - "missing right parenthesis"
and e.entype = 'PRT'
when (t.trans_code not in ('ABDC'))
(smd.user_group_desc3 = '12' and sm.process_sec_type <> 'OPOPSW' and nvl(sw.pay_receive_ind, '0') = 'C') or
(smd.user_group_desc3 = '12' and sm.process_sec_type = 'OPOPSW') or
(smd.user_group_desc3 not in ('3', '25', '12')) or
((smd.user_group_desc3 = '3' and (trim(sm.ticker) = td.transaction_notes) or (t.user_char3 = 'FXO_EXERCISE' and sm.ticker <> 'USD') and e.user_field3 = 'CASH')
(smd.user_group_desc3 = '3' and trim(sm.ticker) = td.transaction_notes and e.user_field3 = 'FUT'
(select distinct ec.user_float10
from pace_masterdbo.codes c,
where c.short_desc = 'ILFUTURESFXF'
and c.instance = cv.code_inst
and ec.user_float10 = rtrim(cv.short_desc)
and trim(ec.entity_id) = trim(ee.user_char1)))
(smd.user_group_desc3 = '25' and t.trade_currency <> 'USD')
and e.user_float5 is not null
We've been working hard for quite some time now and we're finally able to release the latest version of Code Tester for Oracle. You can get it as part of the Toad for Oracle developers Suite at https://support.software.dell.com/toad-for-oracle/12.10. Aside from lots of bug fixes, the key change in this release is we now have a true 64 bit version (along with the 32 bit version).
Lots of new stuff is on the way so stay tuned as we continue to work hard to make Code Tester even better.
Can i test all the packages in my schema at one go or one shot? Can i test selected packages (80-90 packages) from my schema at one shot?
My requirement is to test some selective packages in one shot.
My proc has to results-one is a number and other a string.I need to combine the number with the string as the second output in code tester. i tried the below.
'Member ID ' || e_OUT_MEMBER_ID ||'does not exist'. but output is without the number.
What should i do to get the proper output .I cannot hardcode the value bcoz the id would change.Please advice.
Good afternoon, Advice on DctoCmd.eхe. Completed step import. There metodannye, but there is a package for testing. Package testing is always necessary to create or have a team? -Generate Test definitions / Import = / Generate / T =
Analog button, but the command line
My code is in Schema A, I want to test in Schema A but the extra code that is getting generated for each test case should be stored in Schema B. Please Suggest the Correct approach.
In the exception block of pl/sql code i have raise_application_error(-20001,.......) and when i create a test case and try to run getting the below error
I am testing a function that return a single value and takes 5 as input. For the test values and results I have generated a view where each record consists of the 5 inputs and the correct output value. In setting up the Inputs I select from the view to retrieve multiple values for each input parameter and sort each the same way. I do the same for the outcomes. In the Test Case Properties window I chose "Correlation of values between groups" and then I preview that correlation. All the inputs are matched correctly and appear with their correct outcome and there are 23 records. Now when I run the test the very first record in the group passes and then the rest fail. Upon reviewing the results I notice that the Inputs are all the same record, the first one. The outcomes are the results for each of the 23 records so it appears that the tester is comparing the first set of inputs to each of the 23 outcomes and not comparing each record I saw in the correlation preview to the matching outcome. I am working with a trial version 188.8.131.526.
I am a code tester rookie and could very well be doing something wrong but not sure that that could be.
How to test a function that Anydata input parameter ????/
Database objects are not displayed in code tester, after connection is established
I am getting error message as below, when creating test case for procedure which has result set query build dynamically, took the dynamically created query and tried to equate it will the result set in
outcomes tab using the Query option, please let me know the correct solution for this problem
ERROR Code Tester cannot determine the list of elements in the select list for this test. You must either specify a valid table, view or query in the Properties Window of the cursor variable or you must compare the cursor variable to a static table, view or query (not an expression).
Internal error.Unable to resolve type test_TBL". Please make sure that this type exists in your data base or is "visible" to your connected schema.
Please help to resolve this issue.
each test case its creating a DB package . Feel it would spam the schema. Please let me know if we can have a new user created and store these packages which code tester is creating while executing the test cases..
Ex: i created few test cases for a procedure in a package and executed in code tester.
For each test case a separate db package is created. which will consume space of my database. Please suggest an approach, appreciate quick response
Does Toad Contain tools to help extract specific records with all dependencies.
In code tester for each test case I have some data , when ever a refresh happens the data is not there.
So can I extract specific record with all dependencies from toad so that I can use them again.
Downloaded and installed ver2.6
Getting message as shown in attachment
We just got word that v2.7 is now available on the support portal. Get it while it's hot!!!
A function has couple of test cases, can we pass same input values for all the test cases