Code Tester for Oracle Forum - Toad for Oracle - Toad World
Danny Torres
Follow / 1 Nov 2016 at 1:43pm / Toad for Oracle

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

474 0 / Create an account to join the discussion.
Rajthilak
Follow / 23 Mar 2017 at 7:56am / Toad for Oracle
Latest post by on 23 Mar 2017 at 9:58am

Best way to integrate Sonar to Toad for Oracle Professional 12.0.0...

Expand content
Hi All, Trying to identify bestway to integrate sonar tool into toad to analyse existing code and packages. There are standard quality profile setup in Sonar website across our organisation for each...

Hi All,

Trying to identify bestway to integrate sonar tool into toad to analyse existing code and packages.

There are standard quality profile setup in Sonar website across our organisation for each technology.

Finding way to use sonar tool for existing code.

Toad version: Toad for Oracle Professional 12.0.0.61

Oracle version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Thanks

Unanswered 84 2 / Create an account to join the discussion.
Yashar
Follow / 9 Mar 2017 at 12:11pm / Toad for Oracle
Latest post by on 14 Mar 2017 at 7:40am

overloaded subprograms not listed

Expand content
Overloaded subprograms are not listed. seems like Overload feature is not supported. https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm#i12352 do you have the same problem?

Overloaded subprograms are not listed.

seems like Overload feature is not supported.

https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm#i12352 

do you have the same problem?

Unanswered 73 1 / Create an account to join the discussion.
soden
Follow / 14 Feb 2017 at 1:29pm / Toad for Oracle
Latest post by on 14 Mar 2017 at 7:34am

Customizing Test Definition in Code Tester fails

Expand content
We removed an Argument from the list of parameters for a function and tried to update the Test Definition. In order to remove the argument I: - Open up the Test Editor for the specific Program being...

We removed an Argument from the list of parameters for a function and tried to update the Test Definition. In order to remove the argument I:

- Open up the Test Editor for the specific Program being tested
- Expand list of Test Elements
- Right-click on the removed test element
- Select Remove test element. 

I immediately get the "Unexpected Error Occurred" dialog with the following Message:

Internal error. Test element {...long GUID...} not found in cache collection.

Then whether I cancel or continue to create the support bundle, the dialog repeatedly comes up. I have to End Task on Code Tester to continue working. Unfortunately we are developing on a separate network so I cannot send the support bundle. We are using version 2.0.0.582 of Code Tester.

Anyone know of a solution or workaround?

Thanks,
Mitch

Unanswered 180 1 / Create an account to join the discussion.
j.vaessen
Follow / 15 Feb 2017 at 12:43pm / Toad for Oracle

Code Tester Freeware license expired

Expand content
Hi, I have downloaded recently Code Tester Freeware v2.7. After installation it appears I can't use the program, because I get the message that the edition is expired since 19-July-2016. Does anyone...

Hi, I have downloaded recently Code Tester Freeware v2.7. After installation it appears I can't use the program, because I get the message that the edition is expired since 19-July-2016. Does anyone know a solution? Thanks in advance.

153 0 / Create an account to join the discussion.
Damir Vadas
Follow / 18 Jan 2017 at 11:32am / Toad for Oracle

table rebuild with Mat View

Expand content
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...

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.
Brg
Damir

214 0 / Create an account to join the discussion.
karthik.rajashekaran@gmail.com
Follow / 29 Dec 2016 at 12:45pm / Toad for Oracle
Latest post by on 29 Dec 2016 at 1:35pm

Case Statement in Where clause

Expand content
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' and (case ...

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'

                   and

                      (case

                           when (t.trans_code not in ('ABDC'))

                      then

                        (

                         (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')

                           or

                          (smd.user_group_desc3 = '3' and trim(sm.ticker) = td.transaction_notes and e.user_field3 = 'FUT'

                             and exists

                              (select distinct ec.user_float10

                                   from pace_masterdbo.codes       c,

                                        pace_masterdbo.code_values cv,

                                        rulesdbo.entity_extension  ec

                                  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)))

                           or

                          (smd.user_group_desc3 = '25' and t.trade_currency <> 'USD')

                         )

                       )

                    end)=1

                   and e.user_float5 is not null

350 2 / Create an account to join the discussion.
Gregory Liss
Follow / 29 Sep 2016 at 8:13pm / Toad for Oracle
Latest post by on 22 Dec 2016 at 1:56pm

Code Tester for Oracle v3.0 is out in the wild...

Expand content
All, 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...

All,

  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.

853 1 / Create an account to join the discussion.
christophe.wirtz.external
Follow / 16 Dec 2016 at 7:50am / Toad for Oracle
Latest post by on 16 Dec 2016 at 7:59am

Editor : right click for collapse all (+)

Expand content
Hello, there a was an useful feature, collapse all folds, in TOAD for Oracle editor (v12.6 ?), and I cannot see it anymore, in beta releases too. Is this feature planned yet, in a future version...
Hello,
there a was an useful feature, collapse all folds, in TOAD for Oracle editor  (v12.6 ?), and
I cannot see it anymore, in beta releases too.

Is this feature planned yet, in a future version  ?

Thank you.

Best regards,

Christophe WIRTZ
Oracle Developper


Unanswered 300 1 / Create an account to join the discussion.
tjs_klh
Follow / 19 Jul 2016 at 8:18am / Toad for Oracle
Latest post by on 1 Aug 2016 at 9:44am

Quest Code Tester: test all packages

Expand content
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...

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.

1170 4 / Create an account to join the discussion.
neethubeth
Follow / 7 Jul 2016 at 10:50am / Toad for Oracle
Latest post by on 28 Jul 2016 at 2:14pm

How can I combine a value from a output to another output variabl...

Expand content
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...

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.

Unanswered 975 1 / Create an account to join the discussion.
Karpov Denis
Follow / 10 Mar 2016 at 11:18am / Toad for Oracle
Latest post by on 17 Mar 2016 at 2:28pm

DctoCmd.ехе

Expand content
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...

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

1348 4 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 4 Jan 2016 at 11:21am / Toad for Oracle
Latest post by on 17 Mar 2016 at 6:09am

Want to test the code in SCHEMA A, but the extra code for each test...

Expand content
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.


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.

1124 1 / Create an account to join the discussion.
n_praveen_kumar
Follow / 19 Jan 2016 at 10:49am / Toad for Oracle
Latest post by on 13 Mar 2016 at 6:18pm

How to handle raise_application_error in test cases

Expand content
Hi All, 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 Error.docx

Hi All,

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

Error.docx

1204 1 / Create an account to join the discussion.
dfacch
Follow / 3 Mar 2016 at 8:16pm / Toad for Oracle

Multiple Inputs and Outcomes

Expand content
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...

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 2.7.0.1026.

I am a code tester rookie and could very well be doing something wrong but not sure that that could be.

Unanswered 919 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 11 Jan 2016 at 11:02am / Toad for Oracle

How to test a function that Anydata input parameter ????/

Expand content
How to test a function that Anydata input parameter ????/

How to test a function that Anydata input parameter ????/

Unanswered 1027 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 7 Jan 2016 at 10:27am / Toad for Oracle

Database objects are not displayed in code tester, after connection...

Expand content
Database objects are not displayed in code tester, after connection is established

Database objects are not displayed in code tester, after connection is established 

929 0 / Create an account to join the discussion.
n_praveen_kumar
Follow / 6 Jan 2016 at 2:59pm / Toad for Oracle

Getting Error when running Dynamic Sql

Expand content
Hi All, 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...

Hi All,

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

Type        Description

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).

965 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 5 Jan 2016 at 12:59pm / Toad for Oracle

issue when testing with type

Expand content
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...

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.

962 0 / Create an account to join the discussion.
nitya_kumar_palagiri
Follow / 30 Dec 2015 at 12:11pm / Toad for Oracle

Code tester is creating a db package for each test case which would...

Expand content
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...

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

 

Unanswered 901 0 / Create an account to join the discussion.