0

Am new to PL/SQL i want print the same code in Oracle BI Publisher Procedural Call.

DECLARE message varchar2(20):= 'Hello, World!'; BEGIN dbms_output.put_line(message); END;

Sch Deep
  • 1
  • 1

1 Answers1

0

try this instead

declare
message varchar2(200) := 'Hello World!';
begin
 fnd_file.put_line(fnd_file.output,message);
end;

where message is the same value that u declared before

  • Sorry received the below mentioned error (oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: Invalid column index) and FYI am trying it in Oracle fusion cloud BI Publisher – Sch Deep Apr 10 '20 at 21:09