photo

kaushikc

shared this question
1 year ago

Employees Involved

photo

DMT Support Team

Admin

Statistics

1
Comments
1
Views

Relates to

Share

Tags

1
votes

SSMA Tester queries

Hi,

I am using SSMA tester for unit testing migrated DB but I am running into following issues-

  1. I want to test some stored procedures but their Oracle version contains an out paramter of type cursor for returning data. But on selecting these procedures in test cases I am getting message as 'Unsupported testing objects were selected: Type of parameter cursor is not supported'. What other option do i have for testing these procedures?
  2. Some of the tables I am testing contains large number of rows. So while running test case, during initialization phase, the connection with SQL Server is getting broken while generating RowId column, after which test case execution fails. Test case runs successfully for smaller database. Can we skip generation of RowId column?

Regards,

Kaushik

Official Answer
photo Employee
DMT Support Team Posted 1 year ago

Thank You for your question. Your business is important to us. One of our representatives will respond to your inquiry shortly.

Add Comment

Comments (1)

photo Employee
1

1. SSMA doesn't support conversion of sys_refcursor as OUTPUT parameter, consequently you couldn't create test case for such kind of procedures.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 2M