This discussion is archived
1 Reply Latest reply: Jul 10, 2013 1:22 AM by Martina1018 RSS

Defining the default value for a page item

Mark1970 Newbie
Currently Being Moderated

I've got a page item named P3_MY_ITEM defined in a interactive report page.

When my application goes to this page, I want that in my P3_MY_ITEM text field it's reported the value performed by a PL/SQL.

I've tried to Edit Page Item and in Source --> Source Type I've chosen PL/SQL Expression and in Source Value or Expression I've inserted something like this:

begin
:P3_MY_ITEM := 'xxxxxxxxx';
end;

but it doesn't work.

When I run the application I get:

PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new ......

 

Perhaps I've put things in the wrong manner or in the wrong place

Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points