DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_getcatalogs  31 Aug 14Defects Dependencies

1     
2     /* 
3     ** sp_ijdbc_getcatalogs
4     */
5     
6     CREATE PROCEDURE sp_ijdbc_getcatalogs
7     as
8     
9         if @@trancount = 0
10        begin
11            set chained off
12        end
13    
14        delete #tmp_getcatalogs
15    
16        set transaction isolation level 1
17    
18        insert #tmp_getcatalogs
19        select name from master..sysdatabases order by name
20    


exec sp_procxmode 'sp_ijdbc_getcatalogs', 'AnyMode'
go

Grant Execute on sp_ijdbc_getcatalogs to public
go
DEFECTS
 MGTP 3 Grant to public master..sysdatabases  
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getcatalogs  
 MNER 3 No Error Check should check @@error after delete 14
 MNER 3 No Error Check should check @@error after insert 18
 QISO 3 Set isolation level 16
 MTR1 2 Metrics: Comments Ratio Comments: 5% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 10 6

DEPENDENCIES
PROCS AND TABLES USED
reads table master..sysdatabases (1)  
writes table tempdb..#tmp_getcatalogs (1)