Skip to Content

Default language.

Case 3 - Displaying SQL statements only

The p_change_LOB_storage stored procedure runs SQL statements to apply changes to large objects (LOBs). To display those SQL statements without applying changes to the LOBs, execute the procedure as specified in the following table.

Task

SQL statement

Display the SQL statements that the stored procedure will execute to change the LOBs in table T1866 from out-row to in-row.

Set serveroutput on
exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'ARSYSTEM', p_table_name =>'T1866', p_generate_SQL_only='Yes');

Display the SQL statements that the stored procedure will execute to change all LOBs from out-row to in-row and move them to tablespace AR_LOB.

Set serveroutput on
exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'AR_LOB', p_generate_SQL_only='Yes');

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Remedy Action Request System 20.02