ROS.60050 * ` r
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 ! 8000 " 8000 # 8000 $ 8000 % 8000 & 8000 ' 8000 ( 8000 ) 8000 * 8000 + 8000 , 8000 - 8000 . 8000 / 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v @ r 0878>pB pB
p goqorep p (0@ E Uff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpt tpup nhG_EMPNO g =*%&4 G_de ` 88 q u P 88 0 0 0 88 p &00x $p D r88g25b88 ,08x * Print J 00r100g75b100 ,08x *fpglm 00r100g100b100 @ D2p378>pBppppgQ_1 qfpglmno P Output Mode 1fpgrstuvwpzzp{p~~iDEPT
0 P xbpckl(rpvpppppp [BACKGROUND
t No P Run in BackgrB_ENAME 0 1fpgstuvwxp~~pp000000pppppppp \ORIENTATION No Default P Orientation 1fpgopqrstpzzp{p{{|}~000000pppppppp ]DECIMAL Decimal Indicator 1fpgqrstuvpzzp{p{{|}~000000pppppppp ^THOUSANDS Thousands Indicator 1fpgpqrstupvvpwpwwxy z|0}0~0000pppppppp _CURRENCY Currency Symbol 1fpgnopqrspvvpwpyyz{|}0~00000pppppppp `COPIES 1 Number of Copies 1fpgqrstuvpzzp{p 000000pppppppp aDESFORMAT pdf Destination Format 1fpgopqrstpzzp{p}}~ 000000pppppppp bDESNAME x Destination Name 1fpgopqrstpzzp{p000000pppppppp cDESTYPE Screen P Destination Type 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v x 0 r 88 pv 8z
5no0p0q0r8t8vx z0|0}~0ppppppppr)rLrLrarararararffrgrjjrnrvvwrxre C uRe xg
| 2
H GXJNPRM B(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nopqrpspp frar ar @ @ P jj Report Parameters Enter values for the parameters $00x ! "0 black (00x " $ & white %00x " # green )00x# $& ' darkgreen jk (00x " $ &0 gray96
=
=
= (00x " $ & gray92zzz (00x " $ & gray88 (00x " $ & gray84((( %00x !" #m r0g0b0 z| (00x "$% & r25g0b0 @ (00x "$% &1
r50g0b0 (00x "$% & r75g0b0 (00x "$% & r88g0b0 (00x "$% &v
r100g0b0 (00x!" $ & r0g0b50 *00x "$ & ( r25g0b50@ *00x "$ & ( r50g0b50 *00x "$ & (v r75g0b50 0 *00x "$ & ( r88g0b50 p ,00x $& ( * r100g0b50 (00x!" $ & r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & ( r50g0b75 0 *00x "$ & ( r75g0b75 *00x "$ & ( r88g0b75 ,00x $& ( *
r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ *00x "$ & (
r50g0b88
*00x "$ & ( r75g0b88 0b *00x "$ & (v r88g0b88 p ,00x $& ( * r100g0b88 (00x"# $ &pG r0g0b100 ,00x $& ( *0p ! r25g0b100 @ ,00x $& ( * " r50g0b100 ,00x $& ( *0Z # r75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v @ r .hh ,pvROSATTRIBS class attributes x +hh )ROSLFDESC ros lf descrip L )hh 'rjROSOBJMAP ros name->id C +hh ) ROSSTRINGS tk2 uiStrings D *hh (#fROSSTRUCTS struct types ht *hh (ecROSTK2RESV tk2 reserved or hh onSRW2_ACTION ) n hh unSRW2_ANCHOR p &h!"h# $idSRW2_BODY_LOCATION >< $h h! "
SRW2_DISTRIBUTION '
h h M SRW2_ELEMENT hh SRW2_FIELD @R )h$%h& '0fSRW2_FORMAT_EXCEPTION & "h h @SRW2_FORMFIELD ( hh t SRW2_FRAME er hh raSRW2_GROUP #h h !0SRW2_GROUP_NODE # "h h SRW2_HYPERLINK " $h h! ""SRW2_JAVA_APPLET $ (h#$h% &#SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" #SRW2_LAYOUT_GROUP hh SRW2_LINK " $ hh SRW2_LISTS hh aySRW2_MATRIX 'h"#h$ %mSRW2_OGD_COLUMN_MAP $h h! "SRW2_OG_DOCUMENT #h h !%SRW2_PARAM_FORM hh "SRW2_QUERY 5g %h !h" #0SRW2_TEXT_SEGMENT 88g hh 0TOOL_ACCESS v h h TOOL_COMMENT h h 0 TOOL_LIBRARY
hh TOOL_MODULE hh "TOOL_PLSQL 0g $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH 5 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED 5 )pp "$%& 'VG_COLOR GREEN b75 )pp "$%& 'VG_COLOR BLUE 0b7 "x Empno "x 0 Ename x Job x 88 Mgr %x # Hiredate 0b x & Sal !x 0 Comm * #x ! Deptno " .x , Report Parameters 0p <x : Enter values for the parameters !x $ Dept 75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v P r 88 pv RIBS class attributes x +hh )ROSLFDESC ros lf descrip L )hh 'rjROSOBJMAP ros name->id C +hh ) ROSSTRINGS tk2 uiStrings D *hh (#fROSSTRUCTS struct types ht *hh (ecROSTK2RESV tk2 reserved or hh onSRW2_ACTION ) n hh unSRW2_ANCHOR p &h!"h# $idSRW2_BODY_LOCATION >< $h h! "
SRW2_DISTRIBUTION '
h h M SRW2_ELEMENT hh SRW2_FIELD @R )h$%h& '0fSRW2_FORMAT_EXCEPTION & "h h @SRW2_FORMFIELD ( hh t SRW2_FRAME er hh raSRW2_GROUP #h h !0SRW2_GROUP_NODE # "h h SRW2_HYPERLINK " $h h! ""SRW2_JAVA_APPLET $ (h#$h% &#SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" #SRW2_LAYOUT_GROUP hh SRW2_LINK " $ hh SRW2_LISTS hh aySRW2_MATRIX 'h"#h$ %mSRW2_OGD_COLUMN_MAP $h h! "SRW2_OG_DOCUMENT #h h !%SRW2_PARAM_FORM hh "SRW2_QUERY 5g %h !h" #0SRW2_TEXT_SEGMENT 88g hh 0TOOL_ACCESS v h h TOOL_COMMENT h h 0 TOOL_LIBRARY
hh TOOL_MODULE hh "TOOL_PLSQL 0g $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH 5 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED 5 )pp "$%& 'VG_COLOR GREEN b75 )pp "$%& 'VG_COLOR BLUE 0b7 "x Empno "x 0 Ename x Job x 88 Mgr %x # Hiredate 0b x & Sal !x 0 Comm * #x ! Deptno " .x , Report Parameters 0p <x : Enter values for the parameters !x $ Dept 75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v ` r 88 pv RIBS class attributes x +hh )ROSLFDESC ros lf descrip L )hh 'rjROSOBJMAP ros name->id C +hh ) ROSSTRINGS tk2 uiStrings D *hh (#fROSSTRUCTS struct types ht *hh (ecROSTK2RESV tk2 reserved or hh onSRW2_ACTION ) n hh unSRW2_ANCHOR p &h!"h# $idSRW2_BODY_LOCATION >< $h h! "
SRW2_DISTRIBUTION '
h h M SRW2_ELEMENT hh SRW2_FIELD @R )h$%h& '0fSRW2_FORMAT_EXCEPTION & "h h @SRW2_FORMFIELD ( hh t SRW2_FRAME er hh raSRW2_GROUP #h h !0SRW2_GROUP_NODE # "h h SRW2_HYPERLINK " $h h! ""SRW2_JAVA_APPLET $ (h#$h% &#SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" #SRW2_LAYOUT_GROUP hh SRW2_LINK " $ hh SRW2_LISTS hh aySRW2_MATRIX 'h"#h$ %mSRW2_OGD_COLUMN_MAP $h h! "SRW2_OG_DOCUMENT #h h !%SRW2_PARAM_FORM hh "SRW2_QUERY 5g %h !h" #0SRW2_TEXT_SEGMENT 88g hh 0TOOL_ACCESS v h h TOOL_COMMENT h h 0 TOOL_LIBRARY
hh TOOL_MODULE hh "TOOL_PLSQL 0g $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH 5 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED 5 )pp "$%& 'VG_COLOR GREEN b75 )pp "$%& 'VG_COLOR BLUE 0b7 "x Empno "x 0 Ename x Job x 88 Mgr %x # Hiredate 0b x & Sal !x 0 Comm * #x ! Deptno " .x , Report Parameters 0p <x : Enter values for the parameters !x $ Dept 75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v p \ r V Q(0@@00@@@@@@000000ppp 00880@A11A
AAAAA 1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQRSTde L PBe ` `
jj L PBW2 ` ` L PB ` `
unSRW2_ANCHOR p &h!"h# $idSRW2_BODY_LOCATION >< $h h! "
SRW2_DISTRIBUTION '
h h M SRW2_ELEMENT hh SRW2_FIELD @R )h$%h& '0fSRW2_FORMAT_EXCEPTION & "h h @SRW2_FORMFIELD ( hh t SRW2_FRAME er hh raSRW2_GROUP #h h !0SRW2_GROUP_NODE # "h h SRW2_HYPERLINK " $h h! ""SRW2_JAVA_APPLET $ (h#$h% &#SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" #SRW2_LAYOUT_GROUP hh SRW2_LINK " $ hh SRW2_LISTS hh aySRW2_MATRIX 'h"#h$ %mSRW2_OGD_COLUMN_MAP $h h! "SRW2_OG_DOCUMENT #h h !%SRW2_PARAM_FORM hh "SRW2_QUERY 5g %h !h" #0SRW2_TEXT_SEGMENT 88g hh 0TOOL_ACCESS v h h TOOL_COMMENT h h 0 TOOL_LIBRARY
hh TOOL_MODULE hh "TOOL_PLSQL 0g $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH 5 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED 5 )pp "$%& 'VG_COLOR GREEN b75 )pp "$%& 'VG_COLOR BLUE 0b7 "x Empno "x 0 Ename x Job x 88 Mgr %x # Hiredate 0b x & Sal !x 0 Comm * #x ! Deptno " .x , Report Parameters 0p <x : Enter values for the parameters !x $ Dept 75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v r
p goqorep @00@@@@@@000000ppp 00880@A11A
AAAAA 1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQRSTde L PBe ` `
jj L PBW2 ` ` L PB ` `
unSRW2_ANCHOR p &h!"h# $idSRW2_BODY_LOCATION >< $h h! "
SRW2_DISTRIBUTION '
h h M SRW2_ELEMENT hh SRW2_FIELD @R )h$%h& '0fSRW2_FORMAT_EXCEPTION & "h h @SRW2_FORMFIELD ( hh t SRW2_FRAME er hh raSRW2_GROUP #h h !0SRW2_GROUP_NODE # "h h SRW2_HYPERLINK " $h h! ""SRW2_JAVA_APPLET $ (h#$h% &#SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" #SRW2_LAYOUT_GROUP hh SRW2_LINK " $ hh SRW2_LISTS hh aySRW2_MATRIX 'h"#h$ %mSRW2_OGD_COLUMN_MAP $h h! "SRW2_OG_DOCUMENT #h h !%SRW2_PARAM_FORM hh "SRW2_QUERY 5g %h !h" #0SRW2_TEXT_SEGMENT 88g hh 0TOOL_ACCESS v h h TOOL_COMMENT h h 0 TOOL_LIBRARY
hh TOOL_MODULE hh "TOOL_PLSQL 0g $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID @ +pp $&'( )VG_COLOR CELLID @ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH 5 /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED 5 )pp "$%& 'VG_COLOR GREEN b75 )pp "$%& 'VG_COLOR BLUE 0b7 "x Empno "x 0 Ename x Job x 88 Mgr %x # Hiredate 0b x & Sal !x 0 Comm * #x ! Deptno " .x , Report Parameters 0p <x : Enter values for the parameters !x $ Dept 75g0b100 ,00x $& ( *px $ r88g0b100 ,00x $& ( * %
r100g0b100 &00x " $n & gray pv *00x " $ & ( ' darkgray &00x " $ ( cyan rpO *00x" $ & (n ) darkcyan 0v (00x " $ &_E * gray80333333 (00x " $ & + gray76=p=p=p (00x " $ &j , gray72GGG (00x " $ & | - gray68QQQ '00x! "$ % . r0g25b0 @ O )00x " $& 'j / r25g25b0@ @ r0r )00x " $& '_M 0 r50g25b0 @ )00x " $& ' 1 r75g25b0 @ b8b )00x " $& '0t 2 r88g25b0 @ {| +00x $ &( ) 0 3 r100g25b0 @ *00x" $ & (pO 4 r0g25b50 @ h ,00x $ & ( *0v 5 r25g25b50 @ @ ,00x $ & ( * 6 r50g25b50 @ ,00x $ & ( *p^ 7 r75g25b50 @ ,00x $ & ( *z 8 r88g25b50 @ ,00x $ & ( *| 9
r100g25b50@ *00x" $ & (8d : r0g25b75 0@ p ,00x $ & ( *~ ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *l = r75g25b75 @ ,00x $ & ( * > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & (0 @ r0g25b88 5@ ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( * B r50g25b88 @ ,00x $ & ( *0 C r75g25b88 @ 8000 v r ]0808[ E E
Oracle HTML Navigator
OR_ 0800 6 0800 0808 1 $
AFTERPFORM Dfunction AfterPForm return boolean is
begin
return (TRUE);
end; I B ͫͫͫͫͫͫͫ w SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 & "PKG INIT"AFTERPFORM"" | ! " $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 Q "AFTERPFORM"BOOLEAN"TRUE"" 6
% ) * . 0 4 7 ; = A C O h , Z e O
d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ͫͫͫͫͫͫͫ H ics" % hg !x h
AFTERPFORM d @ @ & ( X0000 VD Dfunction AfterPForm return boolean is
begin
return (TRUE);
end; 0800 0 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept 6JRZc(fjns(z~((((ppppp SQL*ReportWriter REPORT EKU gxjnprm EKUxg
EKUxi
5 ! 5 @ 75g25b88 @ 8000 v r ,00x $ & ( *E D r88g25b88 @ ,00x $ & ( *EA E
r100g25b88@ *00x# $ & (in F r0g25b100 @ to ,00x $ & ( * & G
r25g25b100@ @ ,00x $ & ( *fi H
r50g25b100 @ ,00x $ & ( *il I
r75g25b100 @ ,00x $ & ( * t J
r88g25b100 @ .00x & ( * ,ge K r100g25b100 @ e $00x ! "[0 L red (00x "$% &pa M darkred $00x "/
N blue (00x"# $ &t O darkblue (00x " $ & j P gray64\(\(\( (00x " $ &
Q gray60ffffff (00x " $ &rw R gray56ppp (00x " $ & * S gray52zzz '00x! "$ %nd T r0g50b0 e )00x " $& '/* U r25g50b0@ */ )00x " $& 'f( V r50g50b0 {
)00x " $& 'ge W r75g50b0 );
)00x " $& '/
X r88g50b0 m)
+00x $ &( )ge Y r100g50b0 = *00x" $ & (m, Z r0g50b50
,00x $ & ( *d [ r25g50b50 @ ,00x $ & ( *ni \ r50g50b50 ,00x $ & ( *fo ] r75g50b50 ,00x $ & ( *ue ^ r88g50b50 ,00x $ & ( *ge _
r100g50b50 *00x" $ & (ag ` r0g50b75 0 ); ,00x $ & ( *Y> a r25g50b75 @ ,00x $ & ( *; b r50g50b75 ,00x $ & ( *T c r75g50b75 ,00x $ & ( *.f d r88g50b75 ,00x $ & ( *on e
r100g50b75 *00x" $ & (to f r0g50b88 5 on ,00x $ & ( *>
g r25g50b88 @ ,00x $ & ( *td h r50g50b88 ,00x $ & ( *or i r75g50b88 ,00x $ & ( *AL j r88g50b88 ,00x $ & ( *ce k
r100g50b88 *00x# $ & (0 l r0g50b100 ,00x $ & ( * m
r25g50b100@ ,00x $ & ( * n
r50g50b100 ,00x $ & ( *m o
r75g50b100 ,00x $ & ( *d; p
r88g50b100 .00x & ( * , q r100g50b100 ND '00x "$ % r yellow +00x $ &( ) s
darkyellow *00x "$ & ( t magenta .00x &( * ,KG u darkmagenta | (00x " $ & v gray48 (00x " $ & w gray44\\\ (00x " $ & x gray40 (00x " $ & $ y gray36ףף '00x! "$ % z r0g75b0 )00x " $& ' { r25g75b0@ )00x " $& ' | r50g75b0 )00x " $& 'N" } r75g75b0 )00x " $& 'C ~ r88g75b0 +00x $ &( ) r100g75b0 .08x & ( * , 00r0g75b50 008x ( * , . 00r25g75b50 @ 008x ( * , . 00r50g75b50 008x ( * , . 00r75g75b50 008x ( * , . 00r88g75b50 008x ( * , .se
00r100g75b50 .08x & ( * , 00r0g75b75 0 008x ( * , . 00r25g75b75 @ 008x ( * , . 00r50g75b75 008x ( * , . 00r75g75b75 008x ( * , . 00r88g75b75 008x ( * , .
00r100g75b75 .08x & ( * , 00r0g75b88 5 V 008x ( * , .tu 00r25g75b88 @ 008x ( * , . 00r50g75b88 008x ( * , . 00r75g75b88 008x ( * , .RE 00r88g75b88 008x ( * , .RU
00r100g75b88 .08x ' ( * ,
e 00r0g75b100 8 008x ( * , .e
00r25g75b100@ 008x ( * , .
00r50g75b100 008x ( * , .RT
00r75g75b100 008x ( * , .i
00r88g75b100 25b88 @ 8000 v p r 208x * , . 0E 00r100g75b100 .08x & ( * ,00 00custom1 0 .08x & ( * ,10 00custom2 .08x & ( * ,@ 00custom3 $ .08x & ( * , 00custom4 ( ,08x $ & ( * 00gray32 ,08x $ & ( * 00gray28QQQ ,08x $ & ( *e 00gray24 ,08x $ & ( * 00gray20 +08x % &( )0 00r0g88b0 -08x & (* +" 00r25g88b0@ -08x & (* + j 00r50g88b0 ( -08x & (* +ay 00r75g88b0 -08x & (* +p 00r88g88b0 " $ /08x ( *, - 00r100g88b0 .08x & ( * , 00r0g88b50 b0 008x ( * , . " 00r25g88b50 @ 008x ( * , .& 00r50g88b50 008x ( * , ./
00r75g88b50 008x ( * , . 00r88g88b50 008x ( * , .g5
00r100g88b50 .08x & ( * ,b5 00r0g88b75 0 008x ( * , . 00r25g88b75 @ 008x ( * , . 00r50g88b75 008x ( * , . 00r75g88b75 008x ( * , . 00r88g88b75 008x ( * , .0
00r100g88b75 .08x & ( * , 00r0g88b88 5 b7 008x ( * , . $ 00r25g88b88 @ 008x ( * , . ( 00r50g88b88 008x ( * , .on 00r75g88b88 008x ( * , . 00r88g88b88 008x ( * , .5g
00r100g88b88 .08x ' ( * ,b8 00r0g88b100 008x ( * , .
00r25g88b100@ 008x ( * , .
00r50g88b100 008x ( * , .
00r75g88b100 008x ( * , .
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 ND .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * ,C 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 8 00r50g100b100 e 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .i
00r88g75b100 25b88 @ 8000 v r 208x * , . 0E 00r100g100b100 ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ m4 h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ouq ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ouq 8 h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif , j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif g8 j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif q 1p"&'*. /beforepform
-p "#&* +afterpform 1p"&'*. /afterreport @
p p%p/5670809:;<= >kEMPNO emp.EMPNO EMPNO g @
p p%p/5670809:;<= >nENAME emp.ENAME ENAME
g :
p p#p+/0102034567 8qJOB emp.JOB JOB g :
p p#p+/0102034567 8tMGR emp.MGR MGR g I
p p(p5>?@0A0BCDEF GwHIREDATE emp.HIREDATE HIREDATE g 00 :
p p#p+/0102034567 8zSAL emp.SAL SAL g @ =
p p$p-2340506789: ;}COMM emp.COMM COMM g 8 C
p p&p189:0;0<=>?@ ADEPTNO emp.DEPTNO DEPTNO g
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 ND .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * ,C 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 8 00r50g100b100 e 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .i
00r88g75b100 25b88 @ 8000 v r 1fpglmnopqprrpspsstuvw0x0y0z0{0|0}p~ppppppp iDEPT
Dept DEPT 1fpgmnopqrpvvpwpwwxyz{0|0}0~000p ppppppp jEMPNO h k Empno ` ' EMPNO 1fpgmnopqrpvvpwpwwxyz{0|0}0~000p( ppppppp mENAME h n
Ename ` ' ENAME ACC 1fpgklmnoppvvpwpwwxyz{0|0}0~000p( ppppppp pJOB h q Job _ ' JOB 1fpgklmnoppvvpwpwwxyz{0|0}0~000p ppppppp sMGR h t Mgr ` ' MGR + 1fpgpqrstupvvpwpwwxyz{0|0}0~000p( ppppppp vHIREDATE h w Hiredate ' _ ' HIREDATE 1fpgklmnoppvvpwpwwxyz{0|0}0~000p( ppppppp ySAL h z h w Sal _ ' SAL 1fpglmnopqprrpspsstuvw0x0y0z0{0|0}p~( ppppppp |COMM h } Comm al _ ' COMM 1fpgnopqrspvvpwpwwxyz{0|0}0~000p ppppppp DEPTNO h Deptno @ ' DEPTNO 0 1fpgnopqrspvvpwpwwxyz{0|0}0~000pppppppp PARM01
' PARM01 .bpckl(rpvpv0v0w8x8z|}~x000000p0ppp B_EMPNO 0
ĵe -Țe ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v l 1 $" 6 BEFOREPFORM function BeforePForm return boolean is
--
-- TGKinderman 06/23/2004
-- Core contents of this trigger pulled from OracleTechnologyNetwork (OTN) site as
-- per a trouble shooting example to aid with migration to OracleDS10g*Reports
-- OTN Doc ID = Note:139546.1
--
vc_parameter_form varchar2(4000);
vc_hidden_runtime_values varchar2(1000);
vc_report_name varchar2(100);
hold_cmd VARCHAR2(240);
--
obj ORA_JAVA.JOBJECT;
x VARCHAR2(100);
exc ORA_JAVA.JOBJECT;
-- Exceptions.
--
NO_OBJECT EXCEPTION;
NO_INST EXCEPTION;
NO_ACCESS EXCEPTION;
NO_PASSWORD EXCEPTION;
INVALID_VERSION EXCEPTION;
INVALID_ACCESS EXCEPTION;
NAME_MISMATCH EXCEPTION;
--
-- Exception pragmas.
--
PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100);
PRAGMA EXCEPTION_INIT(NO_INST,-20101);
PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102);
PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103);
PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104);
PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105);
PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106);
begin
--
-- -- Start Security Check
G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( 'GXJNPRM', '7.1' ) ;
-- -- End Security Check
--
:dept := TO_NUMBER(:parm01);
if upper(:desformat) = 'DELIMITED' then
:desformat := 'delimiteddata';
end if;
return (TRUE);
--
exception
WHEN NO_OBJECT THEN
SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.');
return (FALSE);
--
WHEN NO_INST THEN
SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.');
return (FALSE);
--
WHEN NO_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* User not authorized to access FRR134B - report terminated.');
return (FALSE);
--
WHEN NO_PASSWORD THEN
SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.');
return (FALSE);
--
WHEN INVALID_VERSION THEN
SRW.MESSAGE(1000,'*ERROR* Invalid version of FRR134B - report terminated.');
return (FALSE);
--
WHEN INVALID_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.');
return (FALSE);
--
WHEN ORA_JAVA.EXCEPTION_THROWN THEN
SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.');
ORA_JAVA.CLEAR_EXCEPTION;
return (FALSE);
--
WHEN OTHERS THEN
SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190));
--SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - report terminated.');
return (FALSE);
end; + ͫͫͫͫͫͫͫ w SYS STANDARD ORA_JAVA /LgoqorepG$_REPORT_SECURITY SRW $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 C C "PKG INIT"BEFOREPFORM"VC_PARAMETER_FORM"VC_HIDDEN_RUNTIME_VALUES"VC_REPORT_NAME"HOLD_CMD"OBJ"ID"X"EXC":PARM01":DEPT":DESFORMAT"" ! " ( , - / 3 9 = > @ D J N O Q U [ _ ` b f l n t w {
B
#
( # d < # P # # ! " d # % ) ' & ( d p #
+ / - . # 1 ? 3 2 4 0
7 @ 6
: A < ; = 9 # # # " , 5 8 >
$ * 0 6 9 $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 J W W W W |{zyxwv d A e e d A e e d A e e d A l e e d A e e K
e + A
A
A
A
A
A
R A q
A > A A e e
e e A e e A A A A A A A A A A A A A A A e A A e A A e A A e A A e A A e A A e A A e A A e A A e A A e A A e e "BEFOREPFORM"BOOLEAN"VC_PARAMETER_FORM"VARCHAR2"4000"VC_HIDDEN_RUNTIME_VALUES"1000"VC_REPORT_NAME"100"HOLD_CMD"240"OBJ"ORA_JAVA"JOBJECT"X"EXC"NO_OBJECT"NO_INST"NO_ACCESS"NO_PASSWORD"INVALID_VERSION"INVALID_ACCESS"NAME_MISMATCH"EXCEPTION_INIT"G$_REPORT_SECURITY"G$_REPORT_VERIFY_ACCESS"GXJNPRM"7.1"DEPT""TO_NUMBER"PARM01"UPPER"DESFORMAT"="DELIMITED"delimiteddata"TRUE"SRW"MESSAGE"*ERROR* No parameters were passed - report terminated."FALSE"*ERROR* No records found on GUBIPRF - report terminated."*ERROR* User not authorized to access FRR134B - report terminated."*ERROR* No password found on GUBROLE - report terminated."*ERROR* Invalid version of FRR134B - report terminated."*ERROR* Invalid password tried - report terminated."EXCEPTION_THROWN"*ERROR* Report Server Configuration - report terminated."CLEAR_EXCEPTION"ERROR: "||"SUBSTR"SQLERRM"1"190"-20100"-20101"-20102"-20103"-20104"-20105"-20106"7"3"9"13"54"56"66"57"55"51""
% ) * . 0 7 ; > F K L S W Z b g h o s v ~ $%(/03:;>EFIMQRUY]^aeijmquvy} !%(,.26:=@EFKORVXY^bfjmpuv{ "&*-056;?BFHINRVY]adglmrvz} "&*.269<?BEHKNRZ]aijklos{| h , Q Q Q Q k Q k * * * * * * * ] ] ] ] ] ] ] k n n W .
. | n . n
< Z e k Q n W Z e k Q n W Z e k Q n W Z e k Q n W Z e k Q n W Z e k Q n W Z e k k Q n W k W Z e S k Q n | Q Q . . W Z e O c Q c Q c c c c c Q Q Q Q Q Q Q Q c Q c Q c Q c Q c Q c Q c Q c Q c Q c Q c Q c .
! ! ! ! " " " " # # # # ' ' ' ' ' ' ' + + + + + + + + , , , , , , , , , - - - , , , / / / $ 3 4 4 4 4 4 4 4 5 5 5 3 3 3 7 8 8 8 8 8 8 8 9 9 9 7 7 7 ; < < < < < < < = = = ; ; ; ? @ @ @ @ @ @ @ A A A ? ? ? C D D D D D D D E E E C C C G H H H H H H H I I I G G G K K K L L L L L L L M M M M M N N N K K K P Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q S S S P P P 2 T ! " # ' ' ' ' ' + , , , , - - 4 4 4 8 8 8 < < < @ @ @ D D D H H H L L L M Q Q Q Q Q Q Q
#
0 ; %
" l " ) 1 3 " "
# ! # % ) ( ' 0 0 ; ; ) ) "
/
d
%
" # $ ' % + d ) - +
2
/ 0 1 4 2
6
9
<
?
B
E
H 5 J L 8 " N P ; % R T > ( V X A + Z \ D . ^ ` G 1 b d f g # & 4 h k ' n
q
7 o r ! (m s ! " " w " 9 u x # )# $ $ , $ ; z | % -" w % 0 % ~ > }
@ & & '
B
5 ' ( ( ) *) 3 ) G 4 * + ,
J M 8 ' - ( . /+ 7 + O 8 * 0 1
R U ; ' 2 ( 3 4, ; , W <
* 5 6
Z ] > ' 7 ( 8 9- ? - _ @ * : ;
b e A ' < ( = >. C . g D * ? @
j m D ' A ( B C/ G / o H
* D E
r u
F 0 G ' H ( I J1 K 1 w L
K 2 L M * M N
z ~ ' O ( P Q3 P 3 4 R 5 S 6 T 7 U 8 V W T X U V * Y Z
[\ ]^ _ `a b c d e f * g 9 h: i; j< k= l> m? n@ o !p " qr" A s $t % uv% B w *x + yz+ C {
.| / }~/ D 6 1 2 2 E 8 5 6 6 F B 9 : : G 9 = > > H 7 A B B I 3 E F F E 8 I J J @ N O O R S ! ( . 5 8 ; > A D G K O S W [ _ c i j p v y { l t Q
& , 3 7 : = @ C F I M Q U Y ] a e n q w i j p v y { Q G D A > ; 8 5 | d q . ! 5 w n > A ; G 8 ( D , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ͫͫͫͫͫͫͫ H # # ics" Hd$
(E % .% %k k{ .% %k\ kP .% %k0 k$ .0% %k k .L% %k k .h% %k k .% $ %k{ ko . $ l ; % %k k hg ! , ( X BEFOREPFORM & ) * & ) * H ( 0 GXJNPRM 7.1 DELIMITED delimiteddata *ERROR* No parameters were passed - report terminated. *ERROR* No records found on GUBIPRF - report terminated.*ERROR* User not authorized to access FRR134B - report terminated. *ERROR* No password found on GUBROLE - report terminated. *ERROR* Invalid version of FRR134B - report terminated. *ERROR* Invalid password tried - report terminated. *ERROR* Report Server Configuration - report terminated. ERROR: ( D((( D<d DP Hd| Dpd H8 A( A A A$ AD Ad A A A ( * D
' + 3 , ` - l / w } 4 5 8 9 < = @ A + D D E W H p I L M N Q
S T N | } N | N | N | N | + N | W | | d H d
6 H L8 B 0 9 L 7 h <3 p8
@ @ 8000 , 8000 8000 b8 8000 e 8000 8 8000 8000 8000 8000 8000 00 8000 ( 8000 2 08 x* , . 0 e 00r100g88b100 . 08 x& ( * , e 00custom5 . 08 x& ( * , e 00custom6 . 08 x& ( * , e 00custom7 . 08 x& ( * , e 00custom8 , 08 x$ & ( * e 00gray16
, 08 x$ & ( * e 00gray12GGG, 08 x$ & ( * e 00gray8 , 08 x$ & ( * e 00gray4 - 08 x&( *+ e 00r0g100b0 / 08 x( * ,- e 00r25g100b0 @ / 08 x( * ,- e 00r50g100b0 / 08 x( * ,- e 00r75g100b0 / 08 x( * ,- e 00r88g100b0 / 08 x( * ,- e
00r100g100b0 . 08 x'( * , e 00r0g100b50 0 08 x( * , . e
00r25g100b50 @ 0 08 x( * , . e
00r50g100b50 0 08 x( * , . e
00r75g100b50 0 08 x( * , . e
00r88g100b50 2 08 x* , . 0 e 00r100g100b50 . 08 x'( * , e 00r0g100b75 0 08 x( * , . e
00r25g100b75 @ 0 08 x( * , . e
00r50g100b75 0 08 x( * , . e
00r75g100b75 0 08 x( * , . e
00r88g100b75 2 08 x* , . 0 e 00r100g100b75 . 08 x'( * , e 00r0g100b88 0 08 x( * , . e
00r25g100b88 @ 0 08 x( * , . e
00r50g100b88 0 08 x( * , . e
00r75g100b88 0 08 x( * , . e
00r88g100b88 2 08 x* , . 0 e 00r100g100b88 0 08 x(* , . e
00r0g100b100 2 08 x* , . 0 e 00r25g100b100 @ 2 08 x* , . 0 e 00r50g100b100 2 08 x* , . 0 e 00r75g100b100 2 08 x* , . 0 e 00r88g100b100 2 08 x* , . 0 e 00r100g100b100 2 2 5 5 6 6 5 5 7 7
l function BeforePForm return boolean is
--
-- TGKinderman 06/23/2004
-- Core contents of this trigger pulled from OracleTechnologyNetwork (OTN) site as
-- per a trouble shooting example to aid with migration to OracleDS10g*Reports
-- OTN Doc ID = Note:139546.1
--
vc_parameter_form varchar2(4000);
vc_hidden_runtime_values varchar2(1000);
vc_report_name varchar2(100);
hold_cmd VARCHAR2(240);
--
obj ORA_JAVA.JOBJECT;
x VARCHAR2(100);
exc ORA_JAVA.JOBJECT;
-- Exceptions.
--
NO_OBJECT EXCEPTION;
NO_INST EXCEPTION;
NO_ACCESS EXCEPTION;
NO_PASSWORD EXCEPTION;
INVALID_VERSION EXCEPTION;
INVALID_ACCESS EXCEPTION;
NAME_MISMATCH EXCEPTION;
--
-- Exception pragmas.
--
PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100);
PRAGMA EXCEPTION_INIT(NO_INST,-20101);
PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102);
PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103);
PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104);
PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105);
PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106);
begin
--
-- -- Start Security Check
G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( 'GXJNPRM', '7.1' ) ;
-- -- End Security Check
--
:dept := TO_NUMBER(:parm01);
if upper(:desformat) = 'DELIMITED' then
:desformat := 'delimiteddata';
end if;
return (TRUE);
--
exception
WHEN NO_OBJECT THEN
SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.');
return (FALSE);
--
WHEN NO_INST THEN
SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.');
return (FALSE);
--
WHEN NO_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* User not authorized to access FRR134B - report terminated.');
return (FALSE);
--
WHEN NO_PASSWORD THEN
SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.');
return (FALSE);
--
WHEN INVALID_VERSION THEN
SRW.MESSAGE(1000,'*ERROR* Invalid version of FRR134B - report terminated.');
return (FALSE);
--
WHEN INVALID_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.');
return (FALSE);
--
WHEN ORA_JAVA.EXCEPTION_THROWN THEN
SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.');
ORA_JAVA.CLEAR_EXCEPTION;
return (FALSE);
--
WHEN OTHERS THEN
SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190));
--SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - report terminated.');
return (FALSE);
end;tu @ 08000
0 08p 08p 08KGROUND p 08 R i 08 " @ 08 1fgp# t p 08pp3 080p4 08p6 08p 9 RI
00 No ?Def 0
08 OrieP at
08 Q
08fgpopU r
08{|}~W 0 08X 0 08pp[ P 08p ]DEC\ AL p 08 ^ 00cator d 88 1 @ 88uvzpz {p ` 880000 p 88pp 88pp 88DS 88Thousand In 88 88 1fgp q 88wpwpwx z
880p
88p 0
88p UR
88
88mbol
88 1 gp
88vpvwpyp z 88000p 88p p 0 88p 88 1 88 of Copi 88 88stuv z 88000 0 88p 88p 0 88FORMAT P 88 D 88ormat 88 1 88stzpz {p{|}~ 000000pppppppp bDESNAME Destination Name
Y !% Z = $ = [ %% \ > ( > ] )% ^ ? , ? _ 0 l 1 $ AFTERREPORT function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; l ͫͫͫͫͫͫͫ w SYS STANDARD /LgoqorepG$_REPORT_SECURITY $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 & "PKG INIT"AFTERREPORT"" | ! " 5 $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 8 v
$
L "AFTERREPORT"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"FALSE""
% ) * . 0 4 8 ; @ A E H L N R U Y [ \ a e g s u h , k W Z e S Z e O
/
d , plsql_compiler_flags"nls_length_semantics" INTERPRETED,DEBUG"BYTE" ͫͫͫͫͫͫͫ H 6 6 ics" $ %$ %k k hg ! l AFTERREPORT ) d h @ @ rtz/ - 0 Create a new reportppppp p_servername
2
OUTP P_SERVERNAME 1f hpqrstuvzpz{p{p{|}~000000pppppppp P_ACTION d
P_ACTION .bcpklr(vpvpv0w0x8z8|}~x000000p0ppp B_EMPNO 0
ĵe -Țe
FGpWX^(bpbpb0c0f@j8lmnop0q0r0s0t0u0vw0x0yz{|}~p M_G_EMPNO_GRPFR pp 0 h z FGpUVX ZpZpZ0[0^@b8defgh0i0j0k0l0m0no0p0qrstuvwxpx M_G_EMPNO_HDR h z FGpQRV(ZpZpZ0\8^@b8defgh0i0j0k0l0m0no0p0qrstuvwxpx R_G_EMPNO R 0 h %NOpWX^(bpbpb0d8f8h8jklmnopqrs0t0u0vpvpv0wxyz{|}~pp F_EMPNO 0 0 j %NOpWX^(bpbpb8d8f8h8jklmnopqrs0t0u0vpvpv0wxyz{|}~pp F_ENAME 0 0 m ~ %NOpUVZ(^p^p^8`8b8d8fghijklmno0p0q0rprpr0stuvwxyz{|p|p| F_JOB 0 0 6 p ~ %NOpUVZ(^p^p^8`8b8d8fghijklmno0p0q0rprpr0stuvwxyz{|p|p| F_MGR 0 0 T s %NOpZ[^(bpbpb8d8f8h8jklmnopqrs0t0u0vpvpv0wxyz{|}~pp F_HIREDATE 0 0 j v %NOpUVZ(^p^p^@b8d8f8hijklmnopq0r0s0tpvpv0wxyz{|}~pp F_SAL
TE 0 y "{ xx < @ r `2p378>pBpBpBBCD8F8H8J8LNOpPpRRSTZ ^gQ_1 E Uff FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpt tpup nhG_EMPNO g =*%&4 G_EMPNO LIST_G_EMPNO 1fpgpqrstupvvpwp{{|}~000000pppppppp YPRINTJOB Yes P Show Print Job Dialog e 1fpglmnopqprrpsp{{|}~000000pppppppp ZMODE Default P Output Mode 1fpgrstuvwpzzp{p~~000000pppppppp [BACKGROUND
t No P Run in Background 1fpgstuvwxp~~pp000000pppppppp \ORIENTATION No Default P Orientation 1fpgopqrstpzzp{p{{|}~000000pppppppp ]DECIMAL Decimal Indicator 1fpgqrstuvpzzp{p{{|}~000000pppppppp ^THOUSANDS Thousands Indicator 1fpgpqrstupvvpwpwwxy z|0}0~0000pppppppp _CURRENCY Currency Symbol 1fpgnopqrspvvpwpyyz{|}0~00000pppppppp `COPIES 1 Number of Copies 1fpgqrstuvpzzp{p 000000pppppppp aDESFORMAT pdf Destination Format 1fpgopqrstpzzp{p}}~ 000000pppppppp bDESNAME x Destination Name 1fpgopqrstpzzp{p000000pppppppp cDESTYPE Screen P Destination Type 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v P r .bpckl(rpvpv8v0x8z8|~x000000p0ppp B_ENAME 0 * .bpcij(nprpr8r0t8v8xz{|x000000p0ppp B_JOB 0 6 0 6 .bpcij(nprpr8r0t8v8xz{|x000000p0ppp _1B_MGR
0 T 0 T tu .bpcno(rpvpv8v0x8z8|~x000000p0ppp B_HIREDATE 00 j T j 0 .bpcij(nprpr@r0v8x8z|}~x000000p0ppp B_SAL TE 0 j .bpcjk(nprpr@r0v8x8z|}~x000000p0ppp B_COMM E 0 j .bpclm(nprpr@r0v8x8z|}~x000000p0ppp 1B_DEPTNO 0 j .bpchi(jpnpn8n8p8r8tvwxx~~000000p0ppp |PB_1 &r 3 .bpchi(jpnpn8n8p8r8tvwxx~~000000p0ppp 0PB_2 IS .bpckl(rpvpv8v8x8z8|~x000000p0ppp 0PB_DEPT q
S x
i
1
z
D
FpGWX(^pbpb0b0c@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~p M_G_EMPNO_GRPFR pp0 h 0 z FpGUV XpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwpx x0M_G_EMPNO_HDR h z FpGQR(VpZpZ0Z8\@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwpx x R_G_EMPNO R 0 h 0 %NpOWX(^pbpb0b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_EMPNO 0 0 j %NpOWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_ENAME 0 0 m ~ %NpOUV(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{p|p| |F_JOB 00 6 p ~ %NpOUV(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{p|p| |F_MGR 00 T s 0 %NpOZ[(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp F_HIREDATE 00 j v %NpOUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_SAL
TE 0 y %NpOVW(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_COMM E 0 | %NpOXY(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~pp F_DEPTNO 0 0 %NpOWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~pp PF_DEPT 0 0 @ ui 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v