DatabaseProcApplicationCreatedLinks
sybsystemprocssp_passthru  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     
4     /*
5     ** Omni only
6     */
7     create or replace procedure sp_passthru
8         @server varchar(255), /* name of remote server */
9         @query varchar(255), /* language buffer to be executed remotely */
10        @errcode int output, /* error number generated by query */
11        @errmsg varchar(1024) output, /* error message generated by query */
12        @rowcount int output /* number of rows read by the query */
13    
14    /*
15    ** The caller may supply up to 250 additional output arguments of the
16    ** appropriate datatypes to receive the values of successive columns 
17    ** returned from the query.
18    */
19    
20    as
21    /*
22    ** All of the processing, including setting of the return status, is
23    ** handled by the internal OmniSQL Server function "passthru()".
24    **
25    ** A status of 1 is returned if an error is detected during, either
26    ** the remote execution of the language buffer or during the processing
27    ** of the results.  A status of 0 indicates a successful completion.
28    */
29    


exec sp_procxmode 'sp_passthru', 'AnyMode'
go

Grant Execute on sp_passthru to public
go
DEFECTS
 VUWR 4 Variable is an output param and is not written to @errcode 10
 VUWR 4 Variable is an output param and is not written to @errmsg 11
 VUWR 4 Variable is an output param and is not written to @rowcount 12
 MGTP 3 Grant to public sybsystemprocs..sp_passthru  
 MTR1 2 Metrics: Comments Ratio Comments: 74% 7
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 7
 MTR3 2 Metrics: Query Complexity Complexity: 1 7

DEPENDENCIES