QUESTION POSED ON: 18 June 2002
I am new to CLOB, BLOB. I tried a few
examples given in Oracle complete
reference book.
Whenever I run the examples of PL/SQL
procedures using DBMS_LOB or DBMS_OUTPUT
package, I do not get any output
statements at all.
It just quits saying PL/SQL procedure
successfully completed.
For example I ran the following
procedure:
declare
locator_var CLOB;
amount_var INTEGER;
offset_var INTEGER;
output_var VARCHAR2(10);
begin
amount_var := 10;
offset_var := 1;
select Budget into locator_var from Proposal where proposal_id = 1;
DBMS_LOB.READ(locator_var, amount_var, offset_var, output_var);
DBMS_OUTPUT.PUT_LINE('Start of Proposal Text : ' || output_var);
end;
/
It did not give any output.
It just
said PL/SQL procedure successfully
completed.
Do I need to turn ON something to
see the output?
Please let me know.
|
