Prompt in freehand Sql

[nickty]

I am new to BO. I am amending some reports in BO which were created using freehand sql. I need to include a prompt in the report.

At the top of the sql statement i am typing

accept dept prompt 'Enter dept:'

then the select statement

then....

and a_dept_code = '&&dept'

BUT BO throws up an error saying 'The only authorised sql statement is select'

Can anyone help me please??

 

[PAULSGS]

Hi Nicty
You have written the prompt using SQL*Plus syntax.
Rewrite it like this
select statement

then....

and a_dept_code = @Prompt('Enter dept',,,,)

Note I have typed 4 commas after the text, it will work as is but review the BO doc for tips to how these are used