Hi Guys, I am not able to execute below anonymous block i ADS
Sachin Prakash over 9 years ago
To get your PL/SQL syntax to execute without a server error, you need to change it to the following:
call dbms_output.put_line( ‘Hello’ );
PL/SQL syntax was originally created by Oracle and it seems that DB2 added support for it in v9.7. However, the DB2 syntax is different than Oracle’s, as demonstrated by the above example.
ADS supports Oracle’s PL/SQL when connected to Oracle DB. This allows users to view the output of DBMS messages inside of ADS. However, ADS has not added support for PL/SQL when connected to DB2. Hence, when you execute the above dbms_output command, you will not see ‘Hello’ displayed inside of ADS. The DB2 server will process the command dbms_output command but ADS will not be able to read & display its output.
Ravi Rane over 9 years ago
Thanks Sachin for the reply.